Session Details in Distribution Agent

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tejas Parikh - 30 Nov 2005 16:07 GMT

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.
Thank you.

Reply to this Message

Hilary Cotter - 30 Nov 2005 16:17 GMT

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.

Signature

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

> Hey guys. I went to the Agent history for the distribution agent and it
> tells
[quoted text clipped - 5 lines]
> updated.
> Thank you.

Reply to this Message