1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

How can you see what type of locks used?

Question Posted / ranjit

Answer Posted / ranjit

sp_lock to view type of lock applied

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain something about security and SQL Azure?

90

Find nth lowest salary or get nth lowest salary?

597

What is a fan-out query in SQL Azure?

99

How to retrieve error messages using mssql_get_last_message()?

534

What is dknf in normalization form?

556




Explain primary key in sql server?

570

What is msdb database? : SQL Server Architecture

541

What is replace and stuff function in sql server?

567

What is database architecture? : SQL Server Architecture

555

What is service broker?

589

How will you optimize a stored procedure optimization?

517

Explain encryption of entire databases without the need for application changes in sql server 2008?

565

Describe in brief authentication modes in sql server.

569

What is check constraint in sql server?

525

Explain what is the purpose of sql profiler in sql server?

554