Post reply

Suppress output when changing configuration

  • October 27, 2010 at 2:52 am

    #242249

    Hi,

    can I suppress the output of changing settings using T-SQL? How?

    Greets

    pitcher

    [font="Arial"]Kind regards,

    Patrick Fiedler
    Consultant

    Fiedler SQL Consulting

    www.fiedler-sql-consulting.de
    [/font]

  • October 27, 2010 at 3:57 am

    #1242729

    I suppose you want this because you're changing configuration from an application and it raises an error when the message is encoutered, right?

    Then, the answer is simple: don't do that.

    Changing parameters is a sysadmin task. Applications should not have sysadmin privileges.

    -- Gianluca Sartori

  • October 27, 2010 at 4:49 am

    #1242761

    Thanks for the answer.

    No, I only want to suppress the information message because I want to create a script text from this script ... 🙂

    Greets

    pitcher

    [font="Arial"]Kind regards,

    Patrick Fiedler
    Consultant

    Fiedler SQL Consulting

    www.fiedler-sql-consulting.de
    [/font]

  • October 27, 2010 at 6:48 am

    #1242834

    I'm afraid there's no way.

    What you see is the output of a RAISERROR command. I'm not aware of any way to get rid of it.

    -- Gianluca Sartori

  • October 28, 2010 at 2:59 am

    #1243398

    It doesn't matter. 🙂

    Thanks for your information.

    Greets

    pitcher

    [font="Arial"]Kind regards,

    Patrick Fiedler
    Consultant

    Fiedler SQL Consulting

    www.fiedler-sql-consulting.de
    [/font]

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

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