Wednesday, August 11, 2010

Learn to kill blocks in MS SQL Server 2000


Hey DBA's let stop thinking that tables are corrupt. Let start to kill the blocks or locks associated with that table
How to:
Open Enterprise Administrator>
Local instance>
Management>
Current activity>
Locks/Process ID>
Find the process>
kill process>
Done.

No comments:

Post a Comment