Your problem is sections of the code like this.

CREATE DATABASE [@db_name]

where a vriable cannot be used. However in GAL0303s version, dynamic SQL is being used so variables can be substituted...

It is hard to say. Doing it in the ON actually may speed the compile time slightly but in a two table situation the would be almost insignificant. However adding...

For you to get the output to occurr you need to have the TraceID, I usually have written to a table with a description when I doing this. Then when...

If this is a view then it is not able to use variables. This however will do the trick and really do not need the variable in any situation.

select *

from...

Depedns on the size of the data being compared. If not very large and there is a primary key then you could use a select statment with a join to...

If it is listed as a system process it will not let you kill them. If not then no KILL can have the effect of stopping the connection permanently, forcing...

Did you check your job for possiblity of reference to remote server. Also to root it out using Profiler on Backup server and one on Prod server force the job...

Sometimes things with MS apps are truely stranger than fiction.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

I agree with Steve and in fact have seen this happen exactly as stated. If a process cannot complete it will roll back.

"Don't roll your eyes at me. I will...

shut down SQL server and make a file backup of all the SQL files (regular backup and copy files to another location). After doing so the install WINDOWS 2000 fresh...

Break the DTS package into pieces and try it, each time adding a little more until you find exactly what causes the blow up. That is the best way to...

Here this script should help http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=333

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

What tables in particular are not shoiwng up. The fact you registered on EM for 2000 on another machine should not affect you 7 client on the machine without the...

Also keep in mind that Explorer is set to show modified date on the screen, the create date is in the files properties. As a log file contains transaction info...

There are locks added during the read process. It is the same as running SELECT * FROM tbl in any other application. I believe they are intent share locks or...