I want to implement a cascade delete over about 5 tables. I have considered using Sql Server 2005's Cascade delete option on the constraints and would normally do this, but since this is pretty powerful and I am doing a mod I want to put in a more "Localised" solution.
So could you offer up a T-SQL skeleton or some code for a Cascade Delete SP which would be seeded with a UserID. I am actually deleting a user from the ASP.NET membership table with the Membership "DeleteUser" SP, but want to add another SP via trigger to delete all the related records in the application tables.
So what would your solution be for a 5 table cascade delete SP be?
Thanks in advance,