Where can you add custom error messages to sql server?
Disadvantages of the indexes?
Define ACID properties in a Database?
What happens if strings are casted into wrong code pages in ms sql server?
What is clustered primary key?
What is the difference between varchar and nvarchar datatypes?
Explain nested trigger in sql?
Explain how to send email from sql database?
What are the different types of lock modes in sql server 2000?
Difference between drill down and drill through report.
What is relationship? What number of sorts of relationship are there?
What is the disadvantage of using subquery exact after a select statement?ex. select (select * from sometable)
What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages.