August 19, 2011 at 12:05 pm
Where does the View Synchronization Status window get its information? I'm guessing from a stored procedure somewhere.
(I use transact sql)
[font="Arial"]Halfbubble ------------
You just can't do this stuff unless you're at least half a bubble off center.[/font]
August 19, 2011 at 12:26 pm
Did you try Replication Monitor. It gives more information about the objects being synchronized.
I will look around and see if there is a stored procedure that results synchronization status. Another thought is to run profiler and see what t-sql is being used during synchronization
August 19, 2011 at 12:32 pm
Um, the point is, I want to know where the display gets this information so I can use it in my own code...
[font="Arial"]Halfbubble ------------
You just can't do this stuff unless you're at least half a bubble off center.[/font]
August 22, 2011 at 12:06 pm
Whenever I have this type of question I run a trace on the server and capture everything SSMS (or whatever tool) is issuing to the server in terms of SQL and go from there.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
August 22, 2011 at 1:20 pm
The trick seems to be to execute distribution.dbo.sp_replmonitorhelpsubscription, which gives you all sorts of information. Some of it I don't know what do do with, but the status column is interesting...
case status when 1 then 'Started'
when 2 then 'Succeeded'
when 3 then 'In progress'
when 4 then 'Idle'
when 5 then 'Retrying'
when 6 then 'Failed'
else 'Not Known' end,
case warning when 0 then 'No Issues in Replication' else 'Check Replication' end,
:hehe:
[font="Arial"]Halfbubble ------------
You just can't do this stuff unless you're at least half a bubble off center.[/font]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply