These replies are near perfect for our solution.  ! additional question.  Using your SQL:

select dateadd(day,-day(min(getdate())),dateadd(month,-3,dateadd(month,-((month(min(getdate()))-1)%3),min(getdate()))))

HOW can I render this result w/ a TIME = 00:00:00.000?

Many...

thx for the suggestion .. not to sound unappreciative, but I'm aware that I can query the catalog to derive attributes for various objects (eg. DateCreated) .. but this is quite...

bill.turner@skippackridge.com  would be great.  THX!

Scorpion - I'd really appreciate it.  I owe you one -

-bt

Yes, as I originally mentioned, I read the few articles on this and built out the following solution.  The subscription is not picking up CHANGED data at the subscriber side...

Thx for everyone's help across threads here.  Here's a solution which loops thru 135 million rows, deleteing 10,000 rows then commiting:

DECLARE @x

I didn't tick the existing articles -- all I did was add 2 additional articles.   As I mentioned, E/M indicated a Reinitialization is required.   I watched the Snapshot Agent reintialize...

Thanks for the feedback -- here's exactly what I did

Using E/M, I added the 2 articles and yes, SS 2000 alerted me that this requires a reinitialization of the subscritpion...

I found this - can anyone confirm:

Create the table on the subscriber (if not already there)

DTS the data to the subscriber then -