Answer Posted / kunal sain
to drop the constraint from child table when dropping the
constraint from parent table.
Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
What are the recovery models for a database?
Explain the stored procedure?
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
what is memory-optimized nonclustered indexes
Where views are stored in sql server?
Can select statements be used on views in ms sql server?
What is the difference between lock, block and deadlock? : sql server database administration
Can you explain what is the use of custom fields in report?
What are the different SQL Server Versions you have worked on?
What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration
In case you have filters in your report, when filters will be applied in cached report instance?
Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
How exceptions can be handled in sql server programming?
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
What are the benefits of normalization?