SQL Server 2000 SP4.
I have a developer who is trying to modify a stored procedure on the development server. He gets the error:
We aren't going to give him sysadmin role permissions for any reason, but especially not just so he can work on one stored proc. I have searched for that error message and read up on RAISERROR. No where have I been able to find anything stating a person needs sysadmin role to use WITH LOG option.
The stored proc works fine on the production box (I copied it from prod to dev) and the login that calls it has the same permissions as the developer has to the copy on the dev box.
Why is this error coming up?
Why does a user need to have sysadmin role to use WITH LOG?
Is there any way to use WITH LOG and NOT have sysadmin?
-SQLBill
The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875
I have a developer who is trying to modify a stored procedure on the development server. He gets the error:
We aren't going to give him sysadmin role permissions for any reason, but especially not just so he can work on one stored proc. I have searched for that error message and read up on RAISERROR. No where have I been able to find anything stating a person needs sysadmin role to use WITH LOG option.
The stored proc works fine on the production box (I copied it from prod to dev) and the login that calls it has the same permissions as the developer has to the copy on the dev box.
Why is this error coming up?
Why does a user need to have sysadmin role to use WITH LOG?
Is there any way to use WITH LOG and NOT have sysadmin?
-SQLBill
The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875