October 30, 2007 at 10:38 am
I'm somewhat new to the DBA side - I know I've done it before but I can't seem to see where I can see who is running on a database and then how to kill them. Help...
October 30, 2007 at 11:16 am
sp_who
sp_who2
Management | Activity monitor in SSMS
KILL [SPID] to kill the process
October 30, 2007 at 11:37 am
Ok, looks like we don't have analysis services turned on (built) for that server. Is that how it works? It's just turned on?
October 30, 2007 at 12:02 pm
No. Analysis Services is for cubes. Totally different application. You just need to do the stuff in the post above to identify the appropriate SPID and then use the command:
KILL SPID
That'll disconnect the login after it rolls back any open transactions.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply