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

Re: Trigger Stored Proc on Delete from Subscription Class Table

Subject: Re: Trigger Stored Proc on Delete from Subscription Class Table
From: "RDV"
Date: 11 Aug 2006 11:03:19 -0700
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Thanks for the best practice insight.


Joe Webb wrote:
> I tend to shy away from making changes to the SSNS tables, such as
> adding a trigger. It just makes updates and upgrades a little more
> complex.
>
> So, as a result I usually create a job that I can execute periodically
> to do whatever chron table clean up that may be needed in my SSNS app.
>
> 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 11 Aug 2006 08:02:09 -0700, "RDV" <[email protected]> wrote:
>
> >Is it proper to create a trigger on delete stored procedure on the NS
> >subscription table to cleanup any chronicle tables that I have created
> >for my application ?
> >
> >When a subscription is deleted, I want to purge data from some
> >chronicle tables for that subscription id.
> >
> >If not, does anyone have any strategies for keeping these tables
> >cleaned of data that exists for subscriptions that no longer exist.
> >
> >I am using SSNS 2000.


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