I'm trying to ensure that none of the 47 foreign keys in my database are
being enforced for replication. Is this information stored in a system
table?
MichelleCheck the CnstIsNotRepl property using OBJECTPROPERTY function.
--
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"michelle" <michelle@.nospam.com> wrote in message
news:e33lCGsuEHA.1420@.TK2MSFTNGP10.phx.gbl...
> I'm trying to ensure that none of the 47 foreign keys in my database are
> being enforced for replication. Is this information stored in a system
> table?
> Michelle
>|||Thanks!
SELECT * FROM dbo.sysobjects
WHERE
OBJECTPROPERTY(id, N'CnstIsNotRepl') = 0
AND xtype = 'FK'
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:%231CxJMsuEHA.4008@.TK2MSFTNGP10.phx.gbl...
> Check the CnstIsNotRepl property using OBJECTPROPERTY function.
> --
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "michelle" <michelle@.nospam.com> wrote in message
> news:e33lCGsuEHA.1420@.TK2MSFTNGP10.phx.gbl...
>
Monday, February 20, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment