My MVP Profile

Sunday, April 02, 2006

How to Find Friendly Name of a MOM Rule stored procedure

A few months back I posted the T-SQL for finding a Friendly name of a rule when you're confronted with the rule identifier in the Application Event Log. I decided to move it to a stored procedure.

Paste this into Query Analyzer and hit F5 or click the green arrow


--*******Start paste here**************


create procedure SP_Rule_Friendly_Name @strRuleIdentifier uniqueidentifier AS select Name from onepoint.dbo.ProcessRule where idProcessRule=@strRuleIdentifier


Go


--********End paste here*************


To Run:

When complete, call the stored procedure from Query Analyzer as follows:
execute SP_Rule_Friendly_Name '{Rule-GUID}'

Comments on "How to Find Friendly Name of a MOM Rule stored procedure"

 

post a comment links to this post