Saved Bookmarks
| 1. |
Explain What Stored Procedure Sp_replcounters Is Used For? |
|
Answer» Sp_replcounters is a system stored procedure that returns INFORMATION about the TRANSACTION rate, latency, and first and last log sequence number (LSN) for each publication on a server. This is run on the publishing server. Running this stored procedure on a server that is ACTING as the DISTRIBUTOR or subscribing to publications from another server will not return any data. Sp_replcounters is a system stored procedure that returns information about the transaction rate, latency, and first and last log sequence number (LSN) for each publication on a server. This is run on the publishing server. Running this stored procedure on a server that is acting as the distributor or subscribing to publications from another server will not return any data. |
|