SQL Server Performance Forum – Threads Archive

Replication Status

Hi Folks, I need to query MSDB to check the status of Replication(Merge-Agent) to extract the last replication status(succeeded or failed, when did it start, how many inserts-updates and duration, etc) I want these details to be embedded in a VB application so that they could see the replication status rather to allow access them to enterprise-manager. I also need to facilitate the appication to start and stop the merge agent. Please post the details. Thanx in advance.

I havent ever had to do this, but I’d look at WMI or SQL DMO as a possible way of achieving this rather than querying system tables… from BOL
>>>>>>
The SQL Server WMI support is not installed by SQL Server 2000 Setup. All of the WMI materials, including a separate setup and documentation, are included in the folder x86OTHERwmi on the SQL Server 2000 compact disc.
>>>>>> Cheers
Twan

I’ve tried lookin at it but couldn’t…, too many gray areas. If anybody could guide more precisely plz!!!
Thanx.

Have you tried to instal WMi as referred by Twan. Refer to the books online for system supplied stored procedures on Replication process, rather querying the system database as suggested. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

When i execute WMI setup a dialog-box appears saying please wait while windows configure WMI SQL Server provider.Then it disappears. Now what to do and where to start from. Sorry for little knowledge, so bear with me. Haven’t use this before. Now where to start from.
Thanx.[:I]

Hand of articles about WMI:
http://www.databasejournal.com/features/mssql/article.php/1503181
http://www.winnetmag.com/SQLServer/Article/ArticleID/27264/27264.html For books on use of WMIhttp://www.amazon.com/exec/obidos/tg/detail/-/0471399515?v=glance Hope the above would give you information required. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>