Yes! You're right - I am using SQL Server 2005. I
probably should have mentioned that earlier.
was replaced. I have made your suggested changes to my
>-----Original Message-----
>Hello,
>
>It sounds like you're using SQL Server 2005 --
the "Programmability" tab is
>a Management Studio feature.
>
>The notify function is being deprecated in NS for SQL
Server 2005. It has
>been replaced with a view, named <NotificationClassName>.
Instead of calling
>the notify function, you now insert notifications into
this view.
>
>Where the notification class is named 'StockAlert',
>
> SELECT StockAlertNotify(s.SubscriberId, ....
>
>becomes
>
> INSERT INTO StockAlert
> SELECT s.SubscriberId, ...
>
>You must modify the <Action> in the application
definition file
>appropriately.
>
>Let me know if you have any questions, or if my
assumptions are incorrect!
>
>-Colin Meek [MSFT]
>
>--
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>Use of included script samples are subject to the terms
specified at
>
http://www.microsoft.com/info/cpyright.htm. >
>Please do not send e-mail directly to this alias. This
alias is for
>newsgroup purposes only.
>--
>
>"Anna" <anonymous@discussions.microsoft.com> wrote in
message
>news:022401c4b00c$aa0f44c0$a601280a@phx.gbl...
>> Hello,
>>
>> I'm working through the Stock Symbol example in Shyam
>> Pather's book, and I'm having a difficult
>> time locating the notify function, StockAlertNotify()
>> which is referred to in the NSFire1 stored
>> procedure. I've looked under every Programmability tab
>> under the generated databases and could not
>> find it.
>>
>> Where is this function located?
>>
>> What would cause this function to not be generated? Is
it
>> typical that the absence of this function would not
>> generate an error message?
>>
>> Any help would be greatly appreciated.
>>
>> Thanks.
>>
>> Anna
>
>
>.
