question

Pradeep407 avatar image
Pradeep407 asked

Who dropped replication

Hello All,

I have Peer to Peer replication configured. Someone keeps dropping the replication (using sp_removedbreplication). Is there a way i can check who removed the replication. Also, is there a way to check who keeps tweaking my replication (dropping, adding articles etc)

replicationperformancetransactional-replication
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Swilling avatar image
Swilling answered

You could add a trace on that SP and drop results to a table. I just did a quick search and this one would be one way https://www.mssqltips.com/sqlservertip/3259/several-methods-to-collect-sql-server-stored-procedure-execution-history/

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.