Step 1: execute the below statements in Publisher database
EXEC sp_repldone @xactid = NULL, @xact_segno = NULL, @numtrans = 0, @time = 0, @reset = 1
and
EXEC sp_repldone @xactid = NULL, @xact_segno = NULL, @numtrans = 0, @time = 0, @reset = 0
Step 2: execute the below statement in three databases (distribution, nvcorp and nvcorp)
sp_replrestart
Step 3:: execute the below statement in three databases (distribution, nvcorp and nvcorp)
sp_replflush
------http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1145797&SiteID=1
No comments:
Post a Comment