Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AgentJose
Starting Member
1 Post |
 Posted - 2008-11-05 : 23:13:08
|
Hi ALL!Im stuck and need some help. I made a replication monitoring tool for subscription server, that is based on servers jobhistory.The problem is that in SQL 2000 I can retrieve transaction info from the jobhistory table like "1 transaction(s) with 1 command(s) were delivered." but in SQL 2005 it only shows "The replication agent has been successfully started. See the Replication Monitor for more information.". So I cant get any info and wont be allowed to connect to the publisher for retrieving any data ....Is there any other way to retrieve transaction info?Thank you! |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-06 : 09:11:43
|
| You can see under undistributed command in Replication Monitor. |
 |
|
|
|
|
|
Retrieving Transaction info