Find out whether a database is merge subscriber

Hi,
maybe someone can help me with this one.
I need to find out via T-SQL whether a specific database is a subscriber
of a merge publication. The publisher might not be available when
querying this.
I would have expected bit 4 (value 8) of
master.dbo.sysdatabases.category to be set; however, it isn't in my
replicated databases (maybe just for snapshot replication?)
Thanks for any help on this!
Roland
Roland,
you should be able to find the publication in sysmergesubscriptions on the
subscriber.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Find out transactions not replicated

Hi,
I have set up a transactional replication with Publisher,
Distributor and Subscriber on diff servers.
I want to find out (if any) transactions that have not
been replicated from publisher to distributor , and from
distributor to subscriber.
Can you tell me which tables / sprocs I can use to find
this info.
Thank you
Shrikant
use the view MS_distributionstatus to figure out how many commands have to
be replicated; have a look at the UndelivCmdsInDistDB column. You can find
this view in the distribution database.
To get an idea of the commands remaining in the distribution database do
this.
1) connect to your subscriber and query this table.
declare @.varbinary varbinary(300)
select @.varbinary=transaction_timestamp From MSreplication_subscriptions
print @.varbinary
2) with the value for varbinary paste it into the below query - this are the
command waiting to be applied
use distribution
--select From msrepl_transactions where xact_seqno =@.varbinary
exec sp_browsereplcmds @.xact_seqno_start ='0x0001BD2A000055990010'
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"SP" <anonymous@.discussions.microsoft.com> wrote in message
news:0b7701c4e109$48cc99a0$a501280a@.phx.gbl...
> Hi,
> I have set up a transactional replication with Publisher,
> Distributor and Subscriber on diff servers.
> I want to find out (if any) transactions that have not
> been replicated from publisher to distributor , and from
> distributor to subscriber.
> Can you tell me which tables / sprocs I can use to find
> this info.
> Thank you
> Shrikant