sp_lock to view type of lock applied

How can you see what type of locks used?

Question Posted / ranjit

Answer Posted / ranjit

Is This Answer Correct ?

8 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What do you understand by coalesce in sql server?

1002

What is the sql profiler?

901

Is sql server difficult to learn?

867

What is best institute to Learn DotNET And SQL in chennai?

2115

Which rendering formats are affected by the pagesize properties?

134

What is NOT NULL Constraint in sql server 2012?

936

Comment,Datatypes are unlimited

2019

How to delete duplicate rows from table except one?

933

How to add the custom code in Report?

118

How can we check the sql server version?

983

Does a server store data?

866

How many columns can exist together per table?

1104

How to create a new login name in ms sql server?

997

Explain how dts is used to extract, transform and consolidate data?

939

what is normalization? Explain different levels of normalization? : Sql server database administration

1213