[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

Get up to speed quickly with SQLNS 

I support PASS, the Professional Association for SQL Server.

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