开发者

How do I clear the result message data from a SQL query while in the middle of the query?

I am currently using MS SQL Server 2008.

I have a stored procedure that sends an email using sp_send_dbmail. sp_send_dbmail prints "Mail Queu开发者_StackOverflow中文版ed" to the result message. I need to erase this from the result message. Is there a way to fully clear what has been printed to the result message or to mute "print" commands like this from populating at all?


The @exclude_query_output argument suppresses it. By default is set to 0 so you just set it to 1.

More information at documentation: sp_send_dbmail

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜