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.
|
Backup my known things and restoring it into DBA Learners.......
Subscribe to:
Post Comments (Atom)
MYSQL::Setting Validate_Password componet for MySQL Database to ensure password policy settings
Inadequate Password Settings for MySQL Database We observed that the `validate_password%` settings on hostname `<insert hostname>` a...
-
When i trying to load data from MS access (MDB) to SQL ,i am getting the below error. Error: 0xC0209303 at Package, Connection mana...
-
Inadequate Password Settings for MySQL Database We observed that the `validate_password%` settings on hostname `<insert hostname>` a...
-
Jobs failed with below error message. Error Message: Executed as user: XXXXXX-svc. Mail queued. [SQLSTATE 01000] (Message 0) File attachme...
No comments:
Post a Comment