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

Re: NS standard v enterprise

Subject: Re: NS standard v enterprise
From: Joe Webb
Date: Tue, 12 Jul 2005 07:28:23 -0500
Newsgroups: microsoft.public.sqlserver.notificationsvcs
I'm assuming since it's going in production that this is a v2.0 on SQL
Server 2000 installation. Is that right? 

And is it a new installation or are you updating an existing instance?

Any additional information beyond the screenshot? 

In your SubscriptionEventRule, do you join to a linked server that is
perhaps not there at the client site? 

HTH...

Joe


-- 
Joe Webb
SQL Server MVP


~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811 

I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)


On 8 Jul 2005 14:27:21 -0700, "kate" <[email protected]> wrote:

>This has been pass to us from a client in a screenshot, i have re-typed
>it below... (the instance has already been built ok.
>
>.....
>
>Creating Application
>ApplicationName:Tracker
>
>An error occurred when creating the instance stored procedures.
>FailedStoredProcedure:
>Microsoft.SqlServer.NotficationServices.Common.Generator2
>ApplicationName:Tracker
>The rule could not be added <or updated> to the table of rules in the
>application database.
>InstanceName: TrackerInstance
>ApplicationName:Tracker
>RuleId: 1
>RuleName: TrackerSubscriptionEventRule
>RuleType: EventSubscriptionRule
>RuleAction: -- Create notfications for any event since last chronicled
>                                   SELECT
>dbo.TrackerNotificationsN......   rest of text not included in
>screenshot ......
>
>
>
>
>any thoughts?
>
>
>Kate MBCS
>
>Alert Technologies
>http://www.alert-technologies.co.uk
>Get your notification services implementation going in minutes not
>weeks ......


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