Go for better hardware. Also use RAID levels that does not impact much on write performance.

1. Install SQL Server in new system.

2. Script out all logins in the source and run against the destination.

3. backup all user database and restore in destination.

4. script all jobs...

You can also use the procedure sp_resetstatus to recover from emergency/suspect mode.

Could you post the query and the metadata being used.

No luck from myside BOSS. i installed a new 2005 named instance and tried with servername\instancename that worked then servername\instancename123, servername\instancename1234, servername\instancenamewert and servername\instancenameabcd all failed saying server doesn't exist....

i will just summarise it point wise

1. have browser services enabled and running

2. have local and remote tcp/named pipes enabled

3. have named pipes protocol enabled

this will prevent most connection problems.

If its a named instance then you have to specify servername\instancename to connecto to the server specifying  only the server name will not help. You are having a named instance...

Do you have alais setup for the same server calling it in different names. Check that might be you have them created.

I tried the tool it's okay but with more features it will be very good as a single point to be used.

Do you mean to say that SQL 2005 have SPIDs always less than 50 no not at all still the system SPID are between the range till 50 and user...

Could you post us the error part from the error log file when you try to access using advisor. That might give more details than this.

He is using Standard Edition so onlie indexing is not possible. But he has to say what s the error that he gets when he tries to create an index...

A problem with remote transaction between 2000 and 2005 it bugged my head for almost 6 weeks to get a solution. but atlast i got that myself.

create a user named par in the 2005 server then use sp_change_users_login 'update_one','par','par'

Then try logging in that hsould work.

You have to use 3rd party tools for that. There are tools available in net.