October 27, 2010 at 2:52 am
Hi,
can I suppress the output of changing settings using T-SQL? How?
Greets
pitcher
[font="Arial"]Kind regards,
Patrick Fiedler
Consultant
October 27, 2010 at 3:57 am
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
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
October 27, 2010 at 6:48 am
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
It doesn't matter. 🙂
Thanks for your information.
Greets
pitcher
[font="Arial"]Kind regards,
Patrick Fiedler
Consultant
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply