Post reply

ALTER PROCEDURE result message

  • May 17, 2012 at 2:52 pm

    #256649

    This isn't an important issue, but it struck me as strange and I'm curious to see if anyone can explain this behavior.

    I have a stored procedure that is on several different servers. All servers are running version 10.50.2500 of SQL Server. If I issue an ALTER PROCEDURE... command on any of the server except one particular server, the command returns:

    Command(s) completed successfully.

    in the SSMS Messages pane. But on one server, the message returned is:

    ALTER_PROCEDURE - dbo.procedurename

    The procedure is correctly changed in all cases. I've compared the properties of the servers and all configuration settings appear to be the same (excluding stuff like memory, number of procs, etc). I'm just curious as to why one server would return a different message.

  • May 17, 2012 at 2:59 pm

    #1489376

    DDL trigger?

    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

  • May 18, 2012 at 8:45 am

    #1489732

    Aha! That was it! Thanks!

    Shaun

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

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