sql server notification services: Use existing database for notification tables -- sql server notification services

Re: Use existing database for notification tables

Joe Webb
3/28/2006 12:00:00 AM

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.
http://sqlns.blogspot.com/2006/01/using-existing-database-for-our-sqlns.html
HTH...

--
Joe Webb
SQL Server MVP
http://www.sqlns.com

~~~
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]

Re: Use existing database for notification tables

ramadu
3/28/2006 12:00:00 AM

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
ADF...

- Sri

:
[quoted text, click to view]

Re: Use existing database for notification tables

Joe Webb
3/29/2006 12:00:00 AM

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.

HTH...

Joe

--
Joe Webb
SQL Server MVP
http://www.sqlns.com

~~~
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]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server notification services group.