Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002
    Location
    UK
    Posts
    7

    Question Unanswered: How do you hide 'Caution:' messages in Query Analyser Messages?

    Hi,

    I am running a script inside SQL Query Analyser that includes an 'execute sp_rename' statement. This works OK but causes Query Analyser to output a caution message in the Messages pane:

    Caution: Changing any part of an object name could break scripts and stored procedures.

    I realise this could be a valid message in some cases but not mine! So, does anyone know how I can prevent this message from appearing?

    Thanks in advance for any help.

    Michael.

  2. #2
    Join Date
    Dec 2002
    Location
    Czech Republic
    Posts
    249
    Internal message. Use

    select * from master.dbo.sysmessages where error=15477

    to see it.
    By editing this table, you are able to change it or even remove it, but this is not recomended.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •