Disable messages in SQL2008 result set

sql-server sql-server-2008 dataset messages

14,848

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.

14,848

Author by

MihaiV

Updated on June 04, 2022

Comments

MihaiV almost 2 years

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.
- Dark Star1 about 15 years
  
  Would these be messages like the Deprecated feature warnings? I haven't been able to find a way to disable these.
- MihaiV about 15 years
  
  I guess so. One was warning about truncated data, another was that a full-text search contained noise words.
- Kristen about 15 years
  
  What messages did you see when running the SProc in your IDE?
- MihaiV about 15 years
  
  look at the comment above yours!
- Kristen about 15 years
  
  I was hoping you could tell me the exact message when run in your IDE, might be able to help then.