In my previous company we consolidated all development/testing SQL servers (mostly 2000 and few 7.0) onto one VMware ESX server with SAN storage attached.

First, it allowed us to get...

Re-installing client tools on your workstation/laptop would not help in your case as the data is stored on the server. EM is not really corrupted, it just shows incorrect info...

It's kind of funny. I posted similar question about CTE performance almost a year ago:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=149&messageid=289849

but I guess it was too early for anybody to respond.

what's the rate ($) for this position?

Last time I checked australian contract jobs, one of the requirements was being a resident. If you're not, you'd need to apply for immigration and pass all those requirements. And...

I've been using SQL Compare for a few months and I can't agree more with Robert that SQL Compare is an amazing tool. As a DBA I manage over 20 SQL...

Is it possible to restore SQL2K backup into SQL7 server and vice versa?

Or the only choice is DTS?

The source and destination are on the same server. We created a few more DTS packages on that PC - none of them could be opened on another PC, so...