December 4, 2003 at 7:40 am
Does anyone know a way in either VB6 or T-SQL of telling if a database is part of a replicated set up?
I need something that works on the publisher and the subscribers.
Thanks in advance for any help on this.
December 4, 2003 at 10:02 am
You can run:
exec sp_helpreplicationdboption [DBname]
the value 1, mean yes.
December 8, 2003 at 8:27 pm
I'm afraid that the sp_helpreplicationoption only works on publishers. The only thing I can think of is to check to see if there are any tables in your database that start with MS such as MSmerge_contents (this exists is both subscriber and publisher when they have merge replication. On a subscriber you may also see MSsubscription_properties or MSreplication_options. But they doesn't exist in the publisher.
Unfortunately I could not find any one replication stored procedure that would give us the information you are looking for in BOL.
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply