• Management Pack:  SQL Server
  • MP Version:  6.1
  • Product Version:  2008
  • Released:  8/5/2010
  • Publisher:  Microsoft

An SQL Server Service Broker procedure output results Rule

  • ID:  Microsoft.SQLServer.2008.A_SQL_Server_Service_Broker_procedure_output_results_5_Rule
  • Description:   
  • Target:  SQL 2008 DB Engine
  • Enabled:  No

Overridable Parameters

Parameter Name Default Value Description Override
Priority 0  
Severity 0  

Run As Profiles

Name
SQL Server Default Action Account

Alert Details

Message Priority Severity
An SQL Server Service Broker procedure output results Low Information

Rule Knowledgebase

Summary

A procedure that SQL Server Service Broker internally activated output results. Internal procedures should not output results. The Windows application log displays the procedure name, the queue name, and the output results. The event is logged as MSSQLSERVER event ID 9724.
Causes
This rule does not contain any causes.
Resolutions

This message is informational only. There is no action required.

If this rule is not a concern for the database:

  • Disable the rule for this specific database or all databases
External References
This rule does not contain any external references.

See Also for SQL Server Management Pack


Downloads

Back to top
AZURE OPTIMIZATION ASSESSMENT GET STARTED
MIGRATION TO AZURE GET STARTED
SYSTEM CENTER MIGRATION TO AZURE GET STARTED
MIGRATION TO AZURE FOR SQL AND WINDOWS 2008 GET STARTED