Post reply

Altering an existing stored proc

  • August 18, 2010 at 12:28 pm

    #387608

    Greetings great experts.

    I am a bit baffled about a stored proc that I attempted to modify.

    The Alter command threw an error but then the original stored proc is still there.

    I thought that once an error occurs, the existing stored proc is no longer valid.

    what am I missing?

  • August 18, 2010 at 12:42 pm

    #1208699

    If your query to modify an original stored procedure errored out then the process did not complete, therefore it did not modify anything.

    What error did you receive?

    Shawn Melton
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton

  • August 18, 2010 at 1:10 pm

    #1208718

    Alter != Drop + Create

    If the Alter failed, then the change of that proc failed and the original one will still be there.

    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 3 posts - 1 through 2 (of 2 total)

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