Post reply

Store Procedure Error

  • March 25, 2014 at 8:26 am

    #286912

    When I go to execute a SP

    EXEC dbo.usp_UpdateMessageStatus '95B00925-65B0-E311-A287-5CF3FC21D15A'

    I am getting the following error.

    Procedure or function 'USP_UpdateMessageStatus' expects parameter '@MessageId', which was not supplied.

    Can anyone help me.

    Thanks,

    Kevin

  • March 25, 2014 at 8:40 am

    #1699913

    What parameters is the procedure expecting? Run sp_help then the name of the procedure to get a list. Chances are your procedure expects more than the one parameter you have supplied.

    MCITP SQL 2005, MCSA SQL 2012

  • March 25, 2014 at 8:56 am

    #1699926

    Thanks for the help I was able to fix the problem.

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

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