Explain different types of lock modes in sql server 2000?

Question Posted / sudha

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

More SQL Server Interview Questions

Why the trigger fires multiple times in single login?

What is sleeping status in sql server?

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

What is @@error in sql?

Mention the 3 ways to get a count of the number of records in a table.

1.How to check the backup file details if we do not have access to that folder 2.how to check the backup file size without connecting to the folder

How to use union to merge outputs from two queries together in ms sql server?

What is the Main Difference between ACCESS and SQL SERVER?

How to store and query spatial data?

Is it ok to shrink transaction log?

What is the maximum size per database for sql server express?

What are the different types of replication are there in sql server 2000?

For more SQL Server Interview Questions Click Here