Thanks.. I've already gone down these routes..

a) I'm far from annoyed when I get success reported with everyone of them! It means I can take the rest of the morning...

That made me laugh :w00t:.. A good way to start a day, and yes, it's a great analogy for a project.. Especially the part about chasing turds.. Don't expect me...

Yeah, that's true, killing off a rollback that's incomplete will leave your data inconsistent (That's bad by the way) but 0% complete 0 seconds remaining smacks of a hang, especially...

April 1st has arrived in style..

I just wish this were real.

OK, cool, I'll give that a go, thanks.

Interesting idea but I'm not sure it'd work any better than DTS to be honest,  and the scripting of the database will still need to be done, and it's the...

I've thought about a lot of things, buying shares in a strip club , hanging out on Koh Phi Phi

Ummm, Thanks Gail, but isn't that what's already been suggested? SQL_Noob pointed out the separation of the Schema from the users, which I'd forgotten about, and I think it was...

All very helpful comments, but SQL_Noob's right, I'd forgotten about them separating the Schema from the Userbase.. Damn.

Restore was to be done via an OSQL in a batch file....

Damn.. I was hoping there was a much simpler solution.. This is going to create a bit more work than I'd  hoped for..

DTS...

You fixed your own problems Gift, but Loner may not be able to.. Or he may be able to with a few pointers. The things you say may be true,...