Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question
    
Im running into this as well. In part of one of my scripts I want it to enable XP_CMDSHELL, and then when the execution is complete I want it to disable it. In my case, the confirmation message interferes with my process. I do not want the message stating: "Configuration option 'allow updates' changed from 1 to 1. Run the RECONFIGURE statement to install." There must be some tricky way to eliminate this from the output. Thoughts?? –  Mark Mar 7 at 12:45

1 Answer 1

up vote 3 down vote accepted

No. Informational messages cannot be suppressed.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.