In Activity Monitor (Sql Server 2005) or Current Activities (Sql Server 2000), if you suspect a job has been running unusually long, all you see is something like this: SQLAgent – TSQL JobStep (Job 0x1D8274F1H00B7D44912BD78DCADB1AD0 : Step 1) Use this statement to find out the job name: select name from msdb.dbo.sysjobs where job_id = cast(0x1D8274F1H00B7D44912BD78DCADB1AD0…

Say you are migrating databases from one server to another. You don’t want users connect to the old instance by mistake. You can do that by putting them all offline. Below is the script t set nocount on select ‘alter database ‘ + name + ‘ set offline’ from sysdatabases where name not in (‘master’,…