May 21, 2008 at 12:31 pm
Is there a procedure or a system view to know if i database is published to?
I have two different servers and one is a distributor and the other subscribes to one of the the publications but there doesnt seem to be any signs on the subscribed server that its actually published to. Looks like a normal database.
May 23, 2008 at 7:03 pm
on the subscriber, you can look under the replication hive and see local subscription. If that's there, then the database that you are replication is being replicated.
or you can use the following from the distributor:
sp_helppublication [ [ @publication = ] 'publication' ]
[ , [ @found=] found OUTPUT]
[ , [ @publisher = ] 'publisher' ]
-----------------------------
www.cbtr.net
.: SQL Backup Admin Tool[/url] :.
May 30, 2008 at 7:57 am
Is this a push or a pull subscription? IF it's a push, would the subscriber have ANY indications that it's a subscriber (Other than checking the publisher)?
May 30, 2008 at 1:36 pm
steve smith (5/30/2008)
Is this a push or a pull subscription? IF it's a push, would the subscriber have ANY indications that it's a subscriber (Other than checking the publisher)?
Push, and exactly...all I see is that it shows up under local subscriptions on the subscriber. But I need a way to find out in tsql
June 3, 2008 at 9:52 am
Run this at subscriber database.
exec sp_MSenumsubscriptions @subscription_type = 'both'
* Noel
June 4, 2008 at 12:11 am
select name, is_published, is_subscribed from sys.databases
June 4, 2008 at 12:05 pm
it has been my experience that "is_subscribed" does NOT work 😉
* Noel
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply