What does the on update no action do?
can you any body tell me while running BCP Out in instance in sql server 2000 is getting error. Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.?
how many layers of tcp/ip protocol combined of? : Sql server database administration
when we use function instead of procedure? plz tell me the situation with ex?
If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?
OPTIMIZATION OF SP,CURSOR,TRIGGERS
What is normalization and its types?
explain different types of constraints? : Sql server database administration
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
Tell me what is sql profiler?
Explain the different index configurations a table can have?
Explain active/passive and active/active cluster configurations?
What are the steps need to be take improve the speed of a SQLDATA Server?