I agree with the above steps...

but one other option..

you could always check ODBC on the client side...(if it's an MDAC based app)

Agreed.

Just looking for some outputs to prove DB is in good order....ie dbcc check db...or something similar...but that I can run on a prod box

You lost me Jeff....

I need that code to do my deletes...dont' I?

hmm...no i haven't

really didn't think I needed to create any joins because I'm checking for max/min date on createddate

my assumption was that I would not see any dates < my...

fwiw- I've looked at the remaining records and they look correct..

no nulls, etc

shoudln't it delete every record less then that date?

Thanks guys for answering.

I could be wrong, but I don't think it's the time.

It is deleting many records. But when I do a min/max on createddate it is always the...

Grant,

I've now been told that I need to not delete any records from table C.

I'm trying to run this:

declare @DaysToRetainSMALLINT

DECLARE @cutoffdate DATE

SET @daystoretain = '200'

SET @cutoffdate = '12/01/2009'

SELECT@CUTOFFDATE = DATEADD(dd,...

Atif Sheikh

that sounds like the easiest way for me to go...now how to enable cascade deletes?

Grant

Im trying to use your statement:

But when I run the below code I get the error:

"Must declare the scalar variable "@CUTOFFDATE".

declare @DaysToRetainSMALLINT

DECLARE @cutoffdate DATE

SET @daystoretain = '1'

SET @cutoffdate = '12/01/2010'

SELECT@CUTOFFDATE...

I thought about cascade

How do I use cascade in my senario?

Thanks Grant

Is there a way to put all thre into one statement?

thanks

me 2 talkto lee..

all it takes is that one time when you can't re-attach and you'll always use a bak

if you write out the join in sql, you'll most likely see that your parent and child records don't match/or missing record(s)...hence your issue.

That did it!!

Thanks Ninja's_RGR'us