get status of running agent from the system at runtime

  • hi friends,

    i hv implemented the sql 2005 merge replication functionality that is done from management studio in windows application using .net 2.0 and C#.

    i m able to setup the replication and run the agents (snapshot and merge agents) sucessfully using the sql system based stored procedures.

    now my difficulty is when i run the agents i hv to always check their status through management studio. therefore i m not able to show this status in my application to the user.

    i tried for other stored procedures but i don't get the value at runtime.

    so if anyone knows a better solution plz let me know asap.

  • Good. YOu are a c# programmer - take advantage of RMO

    Lookup "Programming with Replication Management Objects" in books online.

    Enjoy.

    ChrisB MCDBA

    MSSQLConsulting.com

    Chris Becker bcsdata.net

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply