Are you upgrading to SQL 2005? There is an upgrade advisor you can run to help with this.

The database size is large, TBs of data, so I'm not sure that's...

Please don't cross post. This is being answered here: http://www.sqlservercentral.com/Forums/Topic433813-338-1.aspx

This should help

http://www.sqlteam.com/article/what-query-plans-are-in-sql-server-memory

Very interesting, and I have ideas, but they're probably ones you've thought of and since I don't have any direct experience with something this scale in 2005, I hope someone...

Yes, use the ATTACH_REBUILD_LOG option (look it up to be sure I'm write) with the attach command.

Or just the first part as a test.

So is a spare fuel bucket in the back now an "open container" 😉

It's all multiple choice, so you don't have to write syntax from memory, but you do need to be able to recognize what a statement is doing.

I believe you...

First you need to post in the appropriate forum to get a response. This isn't a DTS issue. I'll move to the 2000 forums.

Second, not sure what is wrong here....

First, using SA and a blank password is asking for trouble. Even for testing, set up a real login and user with rights to the table.

Second, it's asking for a...

Good points, though I guess you could do what many people do and put in 2 columns in pictures and join one to either table. You'd be wasting a column,...

I'm not a licensing expert, and I'd like to get more clarification, however with 2K, you got a license for Personal Edition, so on every developer's machine, if you had...

We used to test HTTP at times with it to be sure it was working.

If you telnet to some port and it hangs, blinking cursor, then it's likely open and...

Interesting and thanks for the update. I'm not sure E85 is the best choice, though the idea of getting that from sugar or another crop instead of corn could make...

If you are looking to script the database for #1, then right click the database, select Tasks, and there is a Generate scripts option.

For #2, if you want to...