What to check if a User database is locked?

Question Posted / narayana.y

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

More SQL Server Interview Questions

How do I open a .db file?

hi ..i am working as a sql dba.....now i want to learn more about t-sql..... is it possible to learn online.... plz refer any site ..thankq

How do I install sql server?

I have to display ten columns values from diffrent ten tables. how many joins are require?

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?

Do you know the different ddl commands in sql?

How to delete exactly duplicate records from a table?

Why is replication required on the sql server?

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

How to set a database state to offline in ms sql server?

Mention the uses of stored procedures.

For more SQL Server Interview Questions Click Here