microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

Re: Customizing NS instance db - opinions?

Subject: Re: Customizing NS instance db - opinions?
From: Joe Webb
Date: Wed, 01 Mar 2006 07:53:09 -0600
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Are you using SQL Server 2005? If so, you can create the instance and
application database objects in an existing database.



-- 
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)


On 28 Feb 2006 16:38:10 -0800, [email protected] wrote:

>I want just a few more features in my notification application that I
>haven't seen in SQL NS  - the main feature we're desiring is the
>ability for subscribers to maintain their subscriptions.  I know this
>needs to happen in a Sub. Management interface, but here's what I'm
>getting at.  If all I want is simply to add one table into the instance
>DB to store username, password, firstname, lastname, and have
>subscriberID as the primary key, is this a problem?  Also probably some
>custom stored procedures.
>
>I didn't want to have to have a profile/account/login sort of database
>elsewhere and try & maintain duplicate data  between that DB & my NS
>DB.
>
>So theoretically, the user could login to a web site (hitting my custom
>tables & stored procedures to validate their account/password).  Then
>the site would use all the normal views avaialable from NS to allow the
>user to manage their own subscriptions.  Any problems with this?  I
>would still be using Microsoft approved ways to manage subscribers,
>subscriber devices, and subscriptions - through their views.
>Everything would be in one database.

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