[Top] [All Lists]

Re: Use existing database for notification tables

Subject: Re: Use existing database for notification tables
From: Joe Webb
Date: Wed, 29 Mar 2006 06:08:57 -0600
Newsgroups: microsoft.public.sqlserver.notificationsvcs
In SQL Server 2000 NS v2.0, each instance will have it's on database
called <InstanceName>NSMain. Each Application associated with an
instance will have its own database called
<InstanceName><ApplicationName>. That application database will
contain all events, subscriptions, notifications, etc that you define
for the application - regardless of the number. 

In SQLNS 2005, we have some more flexibility. We can choose to have
the instance and / or application databaes objects created in an
existing database. 

So the short answer is: yes.



Joe Webb
SQL Server MVP

Get up to speed quickly with SQLNS 

I support PASS, the Professional Association for SQL Server.

On Tue, 28 Mar 2006 08:40:56 -0500, ramadu <[email protected]> wrote:

>But if I have multiple events that I wish to create, can I club them all 
>into one single database? i.e. if I write multiple EventClasses in one 
>- Sri
>> Not in v2.0 with SQL Server 2000, but you can in SQL Server 2005
>> Notification Services.  I've described the process over in my blog;
>> it's available here. 
>> HTH...

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