Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / xavier k.
Solution #1
Simply execute the sp_who2 active and check out the blocked
by column to check the blocked spid and blocked by spid
Solution #2
select * from sys.sysprocesses where blocked <>0
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain how to maintain a fill factor in existing indexes?
Describe triggers features and limitations?
What do you understand by SQL*Net?
It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio
What is recompile sql server?
Explain the microsoft sql server delete command?
Where do we use trace frag?
Mention the different authentication modes in sql server.
What does it mean to normalize a database and why would you do it?
Explain filtered indexes benefits?
How you provide security to cube? : sql server analysis services, ssas
What is merge replication?
What is the index requirement in SQL Azure?
what are the types of indexes? : Sql server database administration
Explain relational data?
