My central server (MS SQL Server 2000) is currently hosting a number of projects which are no longer in use, have been cancelled, or are hosted elsewhere. I need a process to clean-out obsolete data.
The scope is to prepare a stored procedure which takes a domain ID (usually a 4 char srting) as input parameter and cleans out all database tables for that domain.
There are several tables where the Domain ID stored. Any advise for starters. Let me know if DDL and sample data is needed.
Thanks In Advance for any help