1

I have a setup script that calls sp_configure a few times to set up some system variables, it works fine but I have a few of the following statement

Configuration option '%ls' changed from %ld to %ld. Run the RECONFIGURE statement to install.

with the variables filled in accordingly. Internally I can see sp_configure is calling 

raiserror(15457,-1,-1, @configname, @prevvalue, @configvalue) with log

Is there anything I can do to prevent those informational messages (which are useless to the script, I call RECONFIGURE from inside the script) from displaying in the messages window in MSSMS when a user runs the script?

Scott Chamberlain
  • 1,045
  • 1
  • 9
  • 25

1 Answers1

3

No. Informational messages cannot be suppressed.

Remus Rusanu
  • 52,054
  • 4
  • 96
  • 172