January 17, 2012 at 8:09 am
Hi,
We've changed our process for duplicating our live db to our reports db from a simple backup/restore to using snapshot replication. But now when one of our team of developers wants to alter a stored procedure they get the error:
Msg 21050, Level 14, State 1, Procedure sp_MSreplcheck_publish, Line 16
Only members of the sysadmin fixed server role or db_owner fixed database role can perform this operation. Contact an administrator with sufficient permissions to perform this operation.
Msg 3609, Level 16, State 2, Procedure sp_MyStoredProc, Line 243
The transaction ended in the trigger. The batch has been aborted.
I don't want to give dbo to the whole team and cannot even find sp_MSreplcheck_publish anywhere (is it auto-generated?)
One suggestion online is to use impersonation, but was hoping somebody on here might be able to make a recommendation.
Any help greatly appreciated.
January 26, 2012 at 10:33 am
Where are they trying to alter the SP's? In the Live DB or the Snapshot DB?
-Roy
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply