Where the coders get together :)
Friday, February 4, 2011
Ever got stuck due to SQL Server processes ?
Ever got stuck due to SQL Server processes ?
Here is an easy way of finding the culprit and resolving :)
select * from master..sysprocesses where blocked <> 0
dbcc inputbuffer(<processid>)
kill <processid>
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment