Re: Trigger Stored Proc on Delete from Subscription Class Table

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.