|
SP_WHO2
|
It shows blocking by the presence of blkby column value.
|
|
Sysprocesses
|
select * from master..sysprocesses where blocked >0
|
|
Activity Monitor
|
Open Activity Monitor at any time by pressing CTRL+ALT A.
|
Subscribe to:
Post Comments (Atom)
-
When i trying to load data from MS access (MDB) to SQL ,i am getting the below error. Error: 0xC0209303 at Package, Connection mana...
-
Seamless Data Archiving: Exporting, Importing, and Pruning MySQL Tables Introduction: In the dynamic landscape of database management...
-
An error occurred while starting mirroring. Alter failed for Database 'XXXXX'. (Microsoft.SqlServer.Smo) The remote copy of dat...
No comments:
Post a Comment