Ok, I understand point 3. But point 1. If your db was to go down, and you couldn't backup/restore the last tran log, you would tell the customer that the...

Thanks for replying.

It turned out to be a missing asp file on the server. I only saw the error message when I tried running the report on the server itself....

##temp_table.

I thought global tables remained until they were dropped. And if that's the case, why is it the table remains if created using Query Analyser?

Thanks for replying, David. I went to a Launch event last night, and asked one of Microsoft lot. You can't migrate, but creating new one's is so flexible and easy...

Someone else must have tried to administer sql server 2000 maintenance plans from the 2005 management studio, surely. Has no one replied because no one knows, or because it's a...

Hi Joesph,

Yes, that's right. Seeing as it's possible to edit Jobs on a SQL 2000 server using the 2005 Management Studio, I assumed that it would be possible to do...