Post reply

error messages

  • April 19, 2004 at 9:04 pm

    #107638

    I'm using the sp_rename proc and I get a caution message (15477) with a severity of 0.

    Is there anyway that I can suppress this message? I understand what it is and I don't want to see it any more ever ever again

    Thanks

     

     

     

     

  • April 20, 2004 at 9:41 am

    #503512

    Quote:

    ----

    "It's not possible to suppress error messages from within T-SQL"

    Satya SKJ http://www.SQL-Server-Performance.Com

    -----

     

     

  • April 21, 2004 at 5:54 am

    #503623

    You can change the sp_rename stored procedure ( in master ), and comment the line with

    raiserror(15477,-1,-1)

    I would suggest to create a new (system) stored procedure sp__rename, as a copy of sp_rename but without the raiserror. When you install a new service pack or new version of SQL server, you should verify your sp__rename procedure again ... 

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

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