Perfect! Thanks!

It was this bit...

CREATE PROCEDURE DB2.dbo.Proc2 (@TimeStamp DATETIME)

AS

DELETE FROM Table2 WHERE [DATEADD] < @TimeStamp

GO

That I just couldn't remember the format for!

And yes, as soon as I...

Ignore me... I'm over complicating everything in my head.... I'll just declare a variable with a select from a temp table where I've inserted a date.

Thanks, much appreciated answers.

I've also just realised another problem that I'm going to come up against.

The next stage in this script I'm writing is that it is going to clear...

Thanks all...

I've just done a count and the actual number of rows transferring will be about 3.5 - 4 million rows a day and about 4Gb.

Why do you expect using...

Even with it set to simple though as I try to run an INSERT...