Error trying inserting data into notifications view
I am building a prototype NS app for scheduled notifications. I
specified a stored proc in my schedule event rule. To start with I put
in a 1 liner insert statement in this sp to insert a record into
schedule notifications view with hard coded values ( just to see
whether things work). The record I am trying insert into this view
conforms to the schema for the notification class.
I inserted records into subscribers and subscriptions tables thru
t-sql. I tried manually running this sp by running from query window .
However I am running into this error :
Msg 515, Level 16, State 2, Procedure
NSScheduleNotificationsInsteadOfTrigger, Line 62
Cannot insert the value NULL into column 'RuleFiringId', table
column does not allow nulls. INSERT fails.
The statement has been terminated.
What is going wrong here?