I have set up sql replication on sql 2012 and when I run synchronization, I get the following message:
You do not have permission to run 'SP_TRACE_GENERATEEVENT'.
I am running the replication under user repl_merge as Microsoft recommends and have given alter_trace permissions to the user but I am still getting this message.
What other users do I need to grant alter_trace to for replication to work.
Also, I am aware this error is a known issue from Microsoft, but I need a work around.