How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
which table keeps the locking information? : Sql server administration
What is the definition for sql server 2000?
How to start sql server browser service?
How do I create a stored procedure in sql server?
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 do you mean by an execution plan?
A successfully created SSIS package in SQL Server 2005 runs fine in MS BIDS and Integration Services. But gives error when run through an SQL-Job. What are the possible reasons?
When would you use a before or after trigger?
When a primary key constraint is included in a table, what other constraints does this imply?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
What is the diff between Dynamic queries and static queries
1 Answers CGG, ICS Integrated Computer Solutions,
What is the difference between IN and EXISTS operators in SQL Server?
9 Answers ASD Lab, CSC, Intelligroup,