What stored procedure would you use to view lock information?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

what's the information that can be stored inside a bit column? : Sql server database administration

0 Answers  


my problem is tempdb tempdb(dbname) 77752.95 MB(db size) 25345.03 MB (unallocated size) suppose i increased temp db size 10 gb . after increase the temp db showing 87 gb (dbsize) 25346.03MB(unallocated size)--unallocated size is showing same .please clarify.

1 Answers  


Where to find ntwdblib.dll version 2000.80.194.0?

0 Answers  


What is buffer cash in sql server?

0 Answers  


What is snapshot replication?

0 Answers  






How you can get the list of largest tables in a database?

0 Answers  


Can we create clustered index on composite key?

0 Answers  


Explain full-text indexing?

0 Answers  


can i write function in stored procedure and stored procedure in function and nested procedure.Give one example for each question?

1 Answers   Cap Gemini, TCS,


How to use transact-sql statements to access the database engine?

0 Answers  


WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT?

8 Answers  


What is deploy, process and build? : sql server analysis services, ssas

0 Answers  


Categories