I definitely second (and third) the opinion that the 3 tables are much more flexible. My DB has a managers table and a separate phone table. Wouldn't you know it,...

There is a good article in SQL Server Magazine Dec 2002 called "Avoiding the Red Zone" which describes how to set up a stored procedure to work with SQL Server...

Many people run in to security-types when running DTS packages as jobs, as ThomasH says.  I've had it happen to me a couple times. I have jobs owned by SA...

You could do a a DTS package using a connection to your database and the file as source with a Transform Data Task between them, then schedule the package to...

dbcc checkdb came back OK with no errors

Thisis from BOL = "C2 auditing is necessary if you are running a C2 certified system. A C2 certified system meets a government standard that defines the security level. To...

You're right - it is not actually running. I thought I had configured it properly but I guess I didn't. Now I feel silly. But what format would the file...

The service has been stopped by rebooting (our network admin needed to put on some patches) several times since I turned on the C2 option.

I used the sp_OAGetErrorInfo to get a desc of the error code. On the sp_oamethod calling LoadFromSQLServer line, I get the error "OLE32.DLL has been loaded at the wrong address."...

The package doesn't fire from running the stored proc. The package runs fine with I run it directly from DTS designer.

Permissions shouldn't be a problem the way I have things...

This is just the topic I was looking for! I've been tasked with something that (I think) could easily be solved by executing at DTS pkg via a stored proc,...

I have 2 highly transactional DBs, 1 reporting DB, and 2 not so big DBs. They are used by a web application that should have no less than 2% downtime.

Currently...

Thanks 🙂 Do you have any sources for more complicated configurations (# of processors, RAID, RAM to optimize performance and expand as the database gets bigger)???

Thanks for the script. I need all the help I can get. You mentioned being cautious with this. Could you expand on that? What should I look out for with...

I am thinking of doing this within a stored procedure called from a Cold Fusion application. I'll take a look at BCP in BOL.

Thanks