Explain different types of locks in sql server.
Which table keeps information about stored procedures?
When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?
Can you explain the role of each service?
How to modify an existing stored procedure in ms sql server?
What are the types of subquery?
What is optimistic concurrency?
What is the language structure to add a record to a table?
Explain system views?
What do you mean by stored techniques? How would we use it?
How can you check the version of sql server?
What are the different index configurations a table can have?
What is enhanced database mirroring in sql server 2008?