Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Disable messages in SQL2008 result set

further to these two questions, is there a way to disable the messages that may get sent along with the resultset in SQL2008?

(please note this is nothing to do with the ANSI_WARNINGS setting. Or NOCOUNT.)

Thanks for any help.

Edit: It's not a problem with compatibility settings or table owners. And it's nothing to do with NOCOUNT. Trust me.

like image 509
ctrlalt3nd Avatar asked Dec 09 '22 21:12

ctrlalt3nd


1 Answers

No, there's not a way to disable all messages that get sent along with the result sets. Set nocount on/off doesn't have an effect on these types of messages.

like image 188
Brent Ozar Avatar answered Jan 11 '23 08:01

Brent Ozar