Is there any way to find who whas configured replication in SQL Serve 2008/2005 ?

Question

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Bhushan Kulkarni SSCrazy Points: 2829 More actions · Answer 1

You can check the owner of the jobs created after replication setup. Job for replication snapshot, log reader agent, distribution

Grant Fritchey SSC Guru Points: 399278 More actions · Answer 2

Yeah, someone has 'sa' privileges.

You might also look at the system_health extended event session. It captures some modifications along these lines (but not all).

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt