microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

Re: Error trying inserting data into notifications view

Subject: Re: Error trying inserting data into notifications view
From:
Date: 6 Mar 2006 09:58:19 -0800
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Can you post your SQL?

sudhakar wrote:
> Hi,
>
> 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
> MySchema.ContentSearcher.NSScheduleNotificationsNotificationBatches1';
> column does not allow nulls. INSERT fails.
> The statement has been terminated.
> 
> What is going wrong here? 
> 
> regards
> sudhakar


<Prev in Thread] Current Thread [Next in Thread>