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
So the short answer is: yes.
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
>> 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.