Does that code imply I'll need to make the Date column a clustered key?  There is no Clustered key on the table.

I'm afraid there's no room for a temp table...yes we need some extra disks and I've had them ordered, but meanwhile I have to get these deletes done quickly..

Thanks for that!!!

Jaybee.

Well guys...here's the situation.

There are THREE systems getting handed over, not two, and even more brutally, the handover time has been slashed in HALF - tomorrow afternoon and Friday.  The...

Cheers mate, I would very much like to see this code....

By the way, my attempts to save their necks failed...the software that uses the database runs into five figures just for...

Robert,

I very definitely am, but the deadline for the project is in about 3 hours! It's really management's shortcoming, I'm simply trying to dig them out of a hole.

I will...

That's cool, but what's the syntax if I need to run comparisons on multiple columns in multiple tables?

Secondly, I may need to insert the unmatched rows into the database, any idea how...

You know, that's just how I ended up doing it...all the other scripts kept falling over due to missing tables, but I didn't even realise the Maint Plan had a...

USE Northwind (for example)

GO

sp_MSforeachtable @command1 = "print '?' dbcc DBREINDEX ('?')"

That's it?!?!???  I can put that in a scheduled job and have it reindex my db???

Jaybee.

I don't understand the syntax too well, where do I change the database name or how do I pass the name into the...

Thanks, but I'm asking if that path is sufficient for a UNC - it's been some time since I did NT, and whether putting in a UNC path into the...

Hi Neil,

The SQL services both login with the main domain admin account.

Is it sufficient that I alter the job step to write to the share?

At the moment, it is:

EXECUTE master.dbo.xp_sqlmaint...

Being a DBA is about having good fortune by hard work, ingenuity and being the 'last-man-standing', as it were, the guy who succeeds where all others fail.  The Creme de...

Appreciate the help, the advice, and even the cynicism!

I've indeed put this ball back into the vendors court, having read the finer print of our SLA.

Thanks again,

Jay.