SCRS_GetStatusMessageIDForSeverityForSWD Stored Procedure

In SCRM 2006, SCRS_GetStatusMessageIDForSeverityForSWD gets the status message identifier for a supplied software distribution severity.

SCRS_GetStatusMessageIDForSeverityForSWD @LocaleID
,[ @Severity = ]  '<ALL>'

Arguments

@LocaleID

Type: int

Locale identifier for the installed product.

@Severity

Type: nvarchar

Value for conditioning query against SCRM 2006 SCRS_StatusMessage_Dimension_Viewwith case mapping to ISError, ISInformational, and ISWarning.

Return Code

Type: int

Value: Always 0.

Result Sets

Column name Data Type Description

StatusMessageID

String

Output value from SCRM 2006 SCRS_StatusMessage_Dimension_View.StatusMessageID.

StatusMessageIDLabel

String

Output value from SCRM 2006 SCRS_StatusMessage_Dimension_View.StatusMessageID.

See Also

Other Resources

Sample SCRM Stored Procedures
SCRM 2006 Report Customization
SCRM 2006 SQL Views
SCRM 2006 Stored Procedures