Post reply

Msg 50000, Level 16, State 1, Procedure SP_Automation, Line 1769.

  • February 2, 2012 at 12:33 am

    #267488

    Hi Guys,

    I have a procedure which contains some transactions and some raiserror statements for some validations.

    If i execute the procedure using SA login it throws me a expected error but if i execute the same sp by another user (has only execute rights) i am getting the below error.

    Msg 50000, Level 16, State 1, Procedure SP_Automation, Line 1769.

    Please help me in fixing this issue.

    Thanks in advance.

    Regards,

    Vijay

  • February 2, 2012 at 2:36 am

    #1441626

    Error 50000 is a user-defined error. Check line 1769, look for the RAISERROR statement and see what the code is around that and the conditions that will cause the error to fire.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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