sql server replication: Hi all,

I'm new to Replication.

I'm receiving transaction changes through a Replication - push Subscription
scheduled every
15 minutes. I would like to pull information on this using sql.

Where is this data stored or how do I get this information.
Succeeded, failed, transactions, etc.......

thanks
gv

Query the msrepl_errors table and the MSdistribution_history table in the
distribution database for this info.

--
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]

As well as Hilary's reply, you might also want to set up alters (ie enable
the default ones) so that messages will be automatically received on errors.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

Um, I think you mean alerts:)

--
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]

Sorry - quite right.
Problem with spelllling.
Paul