Hi,

In SQL 2000's Replication Monitor, I could watch the Distribution Agent
durring initial snapshot synchronization and watch the "Last Action" to see
what table was being currently pushed.

In the SQL 2005/2008 Replication Monitor, I've found the Subscription
window, and it tells me that the Distribution Agent is "Running," but I see
no "Last Action" report. Am I missing something, or is that all there is?
For the Snapshot Agent at the publisher, I can see the "Last Action.'"

--
Thank you,

Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org

Hello Daniel,

I understand that you'd like to view the detailed history of Distribution
Agent for transactional replication. You may try the following steps to
view details:

In Replication monitor, select the subscription under left panel.

On right panel->All Subscrptions, and select the subscrption

Right click the Subscrption->View Details, and select "distributor to
subscirber history".

If anything is unclear or you have other comments, please feel free to let
me know. Thank you.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Hello Daniel,

I'm still interested in this issue. If you have any comments or questions,
please feel free to let's know. We look forward to hearing from you.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.