yup all variables [n][var]char default to 1 when no lenght is specified.

This is where the dbs' information is kept... and yes master is a database (system db, just like msdb and model).

the exists is to check if the db exists. If it does exist, it is dropped then recreated. As for the table being created, check if you have...

That's great feeling isn't it . Now you know you don't ahve to listen to him ever.

Short version :

EXEC SP_MSFOREACHDB 'Select ''?'' as DbName, Name from ?.dbo.SysObjects where Status >= 0 and XType = ''P'' order By Name'

Run the test yourself... start profiler, run a simple select statement without go, then again with go... it'll run only once each.

I don't get it actually. The go statement is the batch separator in QA. It just tells where the statement ends, it doesn't actually make it execute over...

Thanx for completing my point. One more thing is that you can save such scripts for documentation and rerun or roll them back when needed.

Learn to use QA, EM more often than not just copies the table with the required changes and reinsert all the data. However a script in QA will make...

You're not trying to fix it... maybe you'd be better off trying it as soons as you can without disrupting normal activities.

Can you rerun the dts package and see if that's what whipped out the db in the first place?

Glad to hear that... but I was reffering to someone on this site needing sql help. We all help when we code, but we actaully get paid doing that...

I'm still waiting for the day where you help someone... maybe it's closer than I expect it to be .

Glad to know it worked... now I just hope I don't have to use this trick myself and that this server lives for more than 48 hours

Yep, especially since another server without a drive is kind of useless .