Supressing Query Output

[Giddygoat]

Hello

I was wondering if it is possible to suppress the following output when I run an "EXEC sp_rename ......"

The COLUMN was renamed to 'Baseline_Value'

My aim is to suppress all messages except for error messages. I already use SET NOCOUNT ON.

Any ideas??

John

 

[JamesLean]

No, I don't think you can do this.

I'm interested to know why you need to? If you're doing it from QA then it doesn't really matter. If you're doing it from some app then just don't process the output.

--James

 

[Giddygoat]

I'm creating a database upgrade script. I want to output a header line for each item in the upgrade script and turn off all other output except errors. Some of the people who run the upgrade scripts get nervous when they see warnings etc. And it is also a pain for our tech support to have to take a bunch of call asking him if the messages are anything to worry about.