Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
I found so many below informational messages (bulk messages with no any error) are logged in the SQL Server error log.
The activated proc 'x' running on queue 'y' output the following: 'z'
I want to stop this logging. Is there any trace flag that can help?
Seems like you have an activation procedure that explicitly outputs the string y (probably using print but possibly raiserror, select, or output).
Why don't you change the procedure so that it doesn't have any output? Output shouldn't be needed when run through service broker. Or if the procedure is also sometimes run interactively, and output is required in that case, you could require a param for output (or create a wrapper procedure and call that instead).
There is no trace flag to suppress activation procedure output from the error log. This was a design decision to assist in troubleshooting activation procedures (since they are not typically run interactively).
