I copied sproc from server 1 to server 2 and run it in server 2, it came out with error like
Server: Msg 262, Level 14, State 1, Procedure ...
CREATE PROCEDURE permission denied in database 'master'
I am in sysAdmin level I am able to exec this sproc, but it doens't.
Can you help? Thank you,