Re: Error trying inserting data into notifications view
Can you post your SQL?
> 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?