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

Re: Something I don't understand.

Subject: Re: Something I don't understand.
From: "Bob"
Date: Wed, 25 Jan 2006 11:47:20 -0500
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Thanks Joe,
I'm stuck for the time being with utilising sql server 2000, because that's 
what the customer's 'new' application uses (developped by another company).
In any case, thanks for your insights.
In the docs and samples they show you existing complete app but nowhere did 
I find instructions on how to proceed step by step from scratch, except 
possibly in a fairly high level lingo that's not at all clear to a newbie 
like me.
Do you know of any place where I can find such information?

Bob

"Joe Webb" <[email protected]> wrote in message 
news:[email protected]
> Hi Bob -
>
>>I'm looking at the notification services docs and I
>>see that the subscribers database needs to be created and the subscription
>>tables get created by executing command and and or XML files and all this
>>underlying databse and underlying tables get created like in the samples.
>
> That's true. SQLNS is a develoment framework so you cannot really pick
> and choose what portions you'd like to implement. However, in many (or
> most) cases you can pretty easily integrate SQLNS into your existing
> process with little duplication. For instance, since you already have
> your data in a specific table, you can use that information as the
> basis for your events. You don't have to submit all the data to the
> SQLNS tables, only a primary key for your table and let the SQLNS join
> to it later on in the notification process.
>
> Additionally with SQLNS 2005, we can opt to have all the SQLNS-related
> database objects to be created in our existing databases. I discuss
> this option 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)
>
>
> On Tue, 24 Jan 2006 17:41:52 -0500, "Bob" <[email protected]> wrote:
>
>>Well lots of things really but anyways ;-)
>>I have an existing app using sql server 200 tables. One of the tables is
>>DeliveriesToBeMade, in it I have all the information about a scheduled
>>delivery (whoto, when, what, HowToNotify - phone or e-mail, phone number
>>e-mail address etc.)  I'm looking at the notification services docs and I
>>see that the subscribers database needs to be created and the subscription
>>tables get created by executing command and and or XML files and all this
>>underlying databse and underlying tables get created like in the samples.
>>Fine, but I already got the subscribers. Its my customer list and we don't
>>want to create an parrallel data entry system for stuff we already have.
>>There's already an app doing that.
>>I already have the DeliveriesToBeMade, every time a new delivery is
>>scheduled in the existing app a new record is created here and it contains
>>all the info I need to pass to the subscriber. I want the notifications to
>>go out twice a day, once at 1630hrs and once at 1830 hours.
>>
>>So  question
>>
>>It looks like I need to use the automatically generated infrastructure for
>>notifications services and pass it information I already have in effcet
>>making duplicates but in another form. Am I right? If yes, how can I do
>>that. If No, same question :-).
>>
>>
>>Thanks for any insights,
>>
>>Bob
>> 



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