How do I determine if a subscription has loopback
detection enabled?
sp_helpsubscription publicationname and look for the value of
loopback_detection. A non zero value means its enabled.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"larry" <anonymous@.discussions.microsoft.com> wrote in message
news:0f3e01c4a59a$3c36afa0$a601280a@.phx.gbl...
> How do I determine if a subscription has loopback
> detection enabled?
Saturday, February 11, 2012
@loopback_detection
Labels:
database,
determine,
loopback_detection,
loopbackdetection,
microsoft,
mysql,
oracle,
server,
sql,
subscription
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment