I've identified about 20 tables, out of 400, that contain most of the data.
I would like to trim these tables down e.g. table xyz from 5.3Gb to
100-200Mb. The difficulty, is choosing a subset of data across these 20
tables which is referentially intact. Particularly when half our RI is
enforced via triggers. I'm using ERwin & DTS, but I figured that it's a
common operation (related to archive/purge) and there would be software
> Does your subset consist of certain tables from the database or select
> from every table in the database? Either way, I'm sure you could create a
> DTS package to do this.
> Dwayne Lanclos
> Microsoft SQL Server Support
> Please reply only to the newsgroups.
> When posting, please state the version of SQL Server being used and the
> error number/exact error message text received, if any.