sql server notification services: Condition Actions -- sql server notification services

Condition Actions

Mana
2/15/2006 1:02:43 AM

sql server notification services:

Hi

I want to create subscriptions with help of condition actions so that
they ll be flexible.

<SqlLogin> is the child of <ConditionAction> element. I read in MSDN
that the user mentioned in <SqlLogin> must be created before creating
the instance and application of notification service. When I tried to
create a new login it asked me for the default database.

Now since the instance and applications are not created; therefore I
cant specify the database while creating the user.

My query is
1. Do I have to specify the default database while creating user or is
there any way to specify database later when the application and
instance databases are created?

2. If there is no way to do above mentioned actions then is it fine if
I create and empty SQL server database and give it as default database,
And then mention the same empty databasename in <Database> element of
ICF and ADF.

Mana

Re: Condition Actions

Joe Webb
2/15/2006 1:26:27 PM

Hi Mana -

You can change the default database for a user at any time.

After your NS database is create (or after you create your instance if
you are using an existing database), you can make use of database
roles provided SQLNS. Using roles such as NSRunService,
NSSubscriberAdmin, etc, make considering security much easier.

Check out
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlntsv9/html/5a70a24c-25cf-4b77-a3a3-1cdf696d9262.htm
for more information on the roles.

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: Condition Actions

Mana
2/20/2006 1:08:08 AM

Thanks Joe!!!

Mana

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.