How can you see what type of locks used?



How can you see what type of locks used?..

Answer / ranjit

sp_lock to view type of lock applied

Is This Answer Correct ?    8 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Determine when to use stored procedure to complete sql server tasks?

0 Answers  


How we can refresh the view?

0 Answers  


How to execute a stored procedure in ms sql server?

0 Answers  


How would you choose between a clustered and a non-clustered index?

0 Answers  


where do you use Isolations?give me some exmpale?

1 Answers  






What is shared lock?

0 Answers  


why would you call update statistics? : Sql server database administration

0 Answers  


How will u test the stroded procedures and functions? difference between SP and Triggers

2 Answers   TCS,


Is it possible to delete duplicate rows in a table without using a temporary table ?

12 Answers   TCS,


can you any body tell me suppose database is suspect mode. how can take to normal?

2 Answers   Teledata,


How do I find sql server instance name?

0 Answers  


Which autogrowth database setting is good?

0 Answers  


Categories