Saturday, 31 January 2026

SQLDBA- Troubleshoot replication issue.

While encounter the error with replication. We can find which table  name and  which record having an issue  with replication with below commands. 


we need to  run these below commands in distribution database.    


-- run below command in distribution data base 

USE <DB name>

GO

SELECT TOP(10)* FROM MSrepl_errors

ORDER BY TIME DESC

-- Take Xact_Seqno & command _id from above resulut set and pass in below command


SELECT * FROM Msrepl_commands

WHERE xact_seqno = 

AND Command_id =


We need to pass below values from above result set. 

EXEC SP_BROWSEREPLCMDS

@xact_seqno_start = '',

xact_seqno_end = '',

@publisher_database_id= 1,

@article_id=1,

@command_id=1




No comments:

Post a Comment

SQLDBA-Login script out

 Hi Team,  I got requirement to compare the login with  role of two instance. i have used below query   run in one instance  and load the da...