Dont move your master. You can't upgrade it to SQL2000 anyway. The users aren't a problem though. All you need to is script them out . Run the attached script...

OK, so I just read the other pages of the post, and its not the VPN....could have been though

The clue here may be more to do with the firewall config and the MTU settings. Try settings the MTU to 1404 to see if this helps. If you can...

See the below page or if you have an MSDN subscription

http://www.microsoft.com/sql/2005/productinfo/ctp.mspx

Why do you want to do that?! Just dont. You wouldn't have two servers with the same IP address. Better to be able to distinguish.

Thanks,  but we aren't using AWE on any of our servers. The pages referenced do not provide any information releating the issues seen. Maybe its just me.....but I doubt it!

Anybody got any info?

I've implemented many client sites with clustering software from Legato. Not sure if you are looking for clustering in a LAN or WAN environment. We've had a lot of sucecss...

Hi Josep,h

Sounds like you have been having a pretty torrid time! One of our production servers was having a similar issue with CPU usage running high during normal usage for...

Plenty. Never any problems. Just need to make sure all your users are out the DB's or use the kill command.

Are you backing up your transaction log? This will remove the inactive entries for the transactions that have completed.

See BOL Truncating the Transaction Log...

Nice Question?! Hmm not to sure! Surely better to do this with the sp_detach and attach commands in t-sql. Faster and neater