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

Declare @retValue int

EXEC @retValue = msdb.dbo.sp_start_job @job_name = 'packagename'

If @retValue = 1

Raiserror ('Failed to start [packagename]', 16, 1, null)

I have had issues with a re-attach...

There is no guarantee on a re-attach so I would always use the bak file.