Checking if a subscriber is marked for reinit -- sql server replication

tek_1975 NO[at]SPAM yahoo.com
4/13/2006 5:39:51 PM

Hello,

Does anyone know the stored procedure (if there is one) used to check
the status of a pull subscriber. Not necessarily the status of if it's
running or not rather I'm looking to query the publisher/distributer to
see if the subscriber is marked for reinitialization. Right now I can
select for status on the 'MSmerge_subscriptions' table but I was
wondering if there is another method using the built in SQL SP's. Like
just pass the subscriber name and pubid to a stored procedure and have
it return the status. Any help would be greatly appreciated.

Thanks!!
Tek_1975

Hilary Cotter
4/18/2006 12:00:00 AM

For transactional use sp_MShelp_subscription_status and check the value of
the out_of_date parameter. For merge check the value of the status column
from

select srvid, db_name, subid, status, subscription_type from
sysmergesubscriptions where pubid<>subid

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]

sql server replication : Checking if a subscriber is marked for reinit