Hei Gurus,

Please tell me is it possible to disable all the foreign key constraints
in an SQL server database using a single SQL statement....
May be some thing like

SET CONSTRAINTS ALL DISABLED

And then to enable

SET CONSTRAINTS ALL ENABLED

Regards,
-Sanu


_____________________________________________________
CONFIDENTIALITY AND PRIVILEGE NOTICE

This electronic mail transmission and any attachment may contain
confidential and/or legally privileged information intended for
the named recipient(s) only. Any review, use, disclosure,
distribution, copying or action regarding the information contained
in this transmission and any attachment by an unnamed recipient is
strictly prohibited. Also, if you are not a named recipient,
please contact the sender immediately and permanently delete
this transmission and any attachment from your computer system.
Thank you.


MS Sql Server LazyDBA home page