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

Re: Application data - where to add

Subject: Re: Application data - where to add
From: "billdebug"
Date: Tue, 7 Feb 2006 09:58:49 -0600
Newsgroups: microsoft.public.sqlserver.notificationsvcs
thanks Joe, just the confirmation I was looking for. I did discern some of 
this for myself while researching yesterday, but you are the man!
and thanks for the link on sent time too.

"Joe Webb" <[email protected]> wrote in message 
news:[email protected]
> Hi -
>
>>I want to take the basic NS application and expand a single table
>>to allow for additional fields in the application. So, I'm thinking of 
>>going
>>back into the ADF and editing that config to include these fields.
> Sure, you can modify the event schema so that it stores additional
> inforamation. However keep this excerpt from BOL in mind:
>
> <BOL>
> If you add or delete fields, updating the application deletes and
> re-creates the event class. This includes dropping and re-creating the
> SQL Server tables and indexes used by this event class. Any data
> existing in the original event class tables is permanently deleted.
> </BOL>
>
>>Now, given that we want these enhanced events to stay in the database
>>forever, and not be purged by NS, and given that the same records will be
>>called on by another application used by subscribers after their
>>notifications are received, is the best idea to just expand the events 
>>table
>>by modifying the ADF?
> The Vacuumer will clean up the events table using the schedule that
> you've created so that may not be the best place to keep information
> that you'd like to retain forever. You may want to consider keeping
> the information in a Chron table.
>
> 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 Mon, 6 Feb 2006 13:30:32 -0600, "billdebug"
> <[email protected]> wrote:
>
>>I have read some posts from Joe Webb about how SQL 2005 NS can use 
>>existing
>>databases and we can write the NS tables to them. My question is the
>>opposite. I want to take the basic NS application and expand a single 
>>table
>>to allow for additional fields in the application. So, I'm thinking of 
>>going
>>back into the ADF and editing that config to include these fields.
>>
>>Now, given that we want these enhanced events to stay in the database
>>forever, and not be purged by NS, and given that the same records will be
>>called on by another application used by subscribers after their
>>notifications are received, is the best idea to just expand the events 
>>table
>>by modifying the ADF?
>>
>>Please ask for more details if necessary. This is my first NS app so
>>somewhat unclear as to terminology and processing.
>> 



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