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)
[quoted text, click to view] On 8 Jul 2005 14:27:21 -0700, "kate" <k@alert-tech.co.uk> 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 ......
We've identified the problem now. The enterprise v standard was a red
herring. The production servers have a case-sensitive collation and the
NS ADF file had one character in the rule in the incorrect case. We had
not run this build against binary collations before so it caught us
out.
problem solved.
an observation for the dev team. Running the NS build in an msi package
or from code via nscontrol makes managing errors almost impossible as
it is a console process. Any chance in future versions of a dll
implementation of nscontrol with a return code ?
thanks for replies
Kate MBCS
Alert Technologies
http://www.alert-technologies.co.uk Get your notification services implementation going in minutes not
weeks ......
