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
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.
SQL Server MVP
Get up to speed quickly with SQLNS
I support PASS, the Professional Association for SQL Server.
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.