sql server replication: Session Details in Distribution Agent -- sql server replication

Session Details in Distribution Agent

Tejas Parikh
11/30/2005 8:07:04 AM

sql server replication: Hey guys. I went to the Agent history for the distribution agent and it tells
me
'A total of 1 transaction(s) with 8 command(s) were delivered.'

Can someone tell me how I can check what was exactly done at this
transaction? I need to know this because I just want to see wut it updated.

Re: Session Details in Distribution Agent

Hilary Cotter
11/30/2005 11:17:56 AM

You can't really other than by using profiler. You can examine what is
waiting to be replicated by using sp_browsereplcmds. If you are using
anonymous subscribers you may notice the transactions hanging around until
they are older than the retention period.

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