We've found that it's typically much easier to store the image as a regular file on the disk, and store it's filename in the database. _Usually_ there is not...

Is the log what's growing? If so, it's possible that your scheduled job is doing lots of updates / deletes, etc. as a single batch which requires more log...

Yup; I believe this is ANSI92 compliant.

SELECT *

FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = 'sometable'

-- Mitch

Not terribly scalable, but you could use a temporary table to do this. For example:

CREATE TABLE #params (ParamValue varchar(5) not null)

INSERT INTO #params('A')

INSERT INTO #params('B')

EXEC spStock '2004'

DROP TABLE #params

Then,...

The option above is what we used to a) limit the size of our log, and b) keep from blocking the entire table during large deletes (we were deleting nearly...

Oh yeah; you can also run

SELECT DATABASEPOPERTYEX('dbname', 'IsAutoClose')

against the database in question, and it'll return 0 for NO, and 1 for YES.

To change this option, you can use Enterprise Manager...

Yes, this is a per-database setting. In Enterprise Manager, right-click the database, and select properties. Select the Options tab, and you'll find the Auto close option from there....

I have found that DTS is much more capable than BCP or BULK INSERT. I've done lots of importing of comma delimited text files, and BCP/BULK INSERT all have...

Your statement that "local user accounts don't have network access" is incorrect. Services running as SYSTEM do not have network access, but local accounts do. Someone already mentioned...