Sample Header Ad - 728x90

Where to find documentation about the log reader procedures?

0 votes
1 answer
172 views
From the replication monitor in sql server transactional replication, when I have a look at what has been replicated, from publisher to the distributor, I get the following picture: enter image description here It does not show on the replication monitor, therefore running the internal procedures to get hold of what has been read from the transaction log and replicated to the distributor I use the following procedure: use [master] exec [distribution]..sp_MSenum_logreader_sd @name = N'myserver-Product-102', @time = N'20170410 16:36:16.917' this gives me the following results: (same data as on the picture above, plus more information) enter image description here **Question:** I am struggling to find any documentation on the stored procedure that I use to find out what the log reader agent has been doing: **sp_MSenum_logreader_sd** where can I find information about this procedure? I also would like to save this info into a temp table or table variable, so that when I spot an error_id that is not zero I can get extra info as you can see below, based on the error_id from the picture above. -- error_id 5467351 comes from the above result set use [master] exec [distribution]..sp_MSget_repl_error @id = 5467351 enter image description here
Asked by Marcello Miorelli (17274 rep)
Apr 11, 2017, 03:44 PM
Last activity: Mar 27, 2023, 03:57 AM