What is @@error in sql?
What do you understand by a view?
What is page-level compression?
What are the instances when triggers are appropriate?
1.What is the deferece between DBMS & RDBMS? 2.How can you trouble shoot? If u will get error while installing sql server? 3.How can u trouble shoot slow running query? 4.how can u trouble log shipping errors? 5.why do we use merge replication instead of T.log replication?
What is difference between commit and rollback when used in transactions?
Explain filtered indexes?
Explain the properties of subqueries in sql server?
How to insert multiple rows with a subquery?
What is dml command?
What are the tables in sql?
How many types of triggers are there?
let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration