Post reply

sp_configure information message

  • June 3, 2009 at 5:56 am

    #205592

    Upon running a successful sp_configure option and reconfigure, SQL throw an informational message like 'Configuration option 'xyz' changed from x to z.' etc.

    Is there a way to avoid those informational messages? A configuration to tell SQL not showing them?

  • June 3, 2009 at 6:01 am

    #1003909

    if you mean that you dont want information message then you can run with NO info Msgs, this will only return error messages 🙂

  • June 3, 2009 at 6:05 am

    #1003912

    I thought so that something like no error msgs existed but I didn't find it hence the post!

    I'll take a look again.

  • June 3, 2009 at 6:16 am

    #1003915

    Are you able to tell me the command name? I'm googling and still find nothing, so I presume I'm not looking for the good keywords.

  • June 3, 2009 at 6:47 am

    #1003943

    I've found and remember that WITH NO_INFOMSGS suppress information but it is used mostly with DBCC statements and does not apply to reconfigure.

Viewing 5 posts - 1 through 4 (of 4 total)

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