>exec sp_fkeys @fktable_name=
>
>Returns lots of information, but doesn't seem to include whether the checkboxes for whether or not to enforce the constraints:
>
> "Enforce relationship for INSERTs and UPDATEs"
>
>I don't see this in the SysObjects table. Anyone know how to get this information?
>
>Thanks in advance!
>Mike
you can get this from
sp_helpconstraint under the heading
status_enabledinclude the 'nomsg' parameter, e.g.
exec sp_helpconstraint 'mytable', 'nomsg'
Insanity: Doing the same thing over and over and expecting different results.
