You say the data is in a massive text string....but what data type is the column? According to the BOL, the maximum Bytes per row is 8,060 and you say...

Nothing works without TEMPDB. If it grows too big, it will have a chain-reaction down through the rest of the databases, to include making them temporarily unusable. An...

ARGH! I needed sleep that day - or maybe I WAS asleep.

-SQLBill

This is a SQL Server site....so the DATE TIME format should be YYYYMMDD HH:SS:MM.

At least that's my 2 cents.

-SQLBill

Yes. Open Enterprise Manager, expand until you see the database, right click on the database, select Properties, go to the Options tab. You will see Auto Close there,...

Go to Services on the server. Find the SQLServerAgent service. Look for the column 'Log on as'. What does the agent use for a login? THAT is what...

This is directly from the BOL's section on SET ANSI_NULL

The SQL-92 standard requires that an equals (=) or not equal to () comparison against a null value evaluates to FALSE.

...

When...

Daylight Saving Time??? What's that I live in Arizona and we don't do that foolishness.

-SQLBill

Wow, we haven't come across that one (SQL logins falling under the domain security policy).

You're going to find out that DTS and SQL Server 2005 don't play well with each...

Check the timing. When do you have it scheduled to run? Try running it manually at that time and see if it is just as slow. When you run...

Wow, you think you are on a huge learning curve now? And you are just dealing with Management Studio.... Wait til you start with SSIS - that is LOADS...

The actual backup file size doesn't mean anything. What are the actual sizes of the data and log files?

The Data and Log files have empty space, that space won't be...

That is correct...until TEMPDB is available you can't do anything.

-SQLBill

Ouch!!!! I just noticed what I missed before.

copied them from the currently running server onto a CD then onto the laptop.

Can't do that. No, No, No. ...

Same with the last value....it's more than 11 digits.

-SQLBill