compilation error

While compiling my ADF I am getting the foll. error:

Notification Services could not obtain an identifier needed to construct a Transact-SQL statement

I am trying to create an scheduled subscription with a user-defined rule. I followed the instructions on Shyam Pather's book on SQLNS and was able to create the event-trigerred subscription with user-defined logic. But when I tries to extend this to a scheduled subscription I got this error.

I have searched the net for this but could find no other info on this error?

Any idea what this could mean?

Thanks

DK

Detailed Error:

===================================

An attempt to run a Transact-SQL CREATE PROCEDURE statement failed.
Instance Name: ContentMonitorAlerts
Application Name: ContentAlerts
Stored Procedure Name: NSFireDeveloperDefined%RuleId%
SQL Command Text:

DECLARE @.ruleId INT

SELECT @.ruleId=RuleId
FROM [ContentMonitorAlerts].[ContentAlerts].[NSRules]
WHERE RuleName=N'MatchNewContentsForSubscription'
IF @.ruleId IS NULL
BEGIN
RAISERROR (N'9714: Notification Services could not obtain an identifier needed to construct a Transact-SQL statement.', 16, 1)
RETURN
END

DECLARE @.commandText NVARCHAR(MAX)
SET @.commandText = N'
CREATE PROCEDURE [ContentAlerts].[NSFireDeveloperDefined' + CAST(@.ruleId AS NVARCHAR(MAX)) + N']
AS
BEGIN

I noticed that the error says there was an error while running NSFireDeveloperDefined%RuleId%

I am not sure why NS is trying to run that SP - since I am creating a user-defined rule and not a developer defined rule.

Any light on this issue would be greatly appreciated.

Thanks
DK

|||

I solved it by making some changes to the ADF file.

Thanks

|||What changes you have done to resolve your problem ?