SQL server rename

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi All
I am hoping someone has seen this problem before and can help me out.
I had to rename the server that I am running sql server 2000 (SP4) on. After the reboot all seemed ok. I then ran the sp_dropserver'oldname' and sp_addserver'newname','local' commands. When I ran the select @@servername after rebooting I got the correct name back (as in the hostname was returned).
I then ran up enterprise manager and deleted the old registration and added a new one. I could then connect and look at my databases. However when I right click on a database table (in enterprise manager) and select return all rows nothing happens. Eventually I get an ODBC error message saying there was a timeout error.
If I use query analyser I can connect to the database no problem. If I then run a select statement on a table query analyser status goes to executing query batch job and never returns. I have to manually cancel the query before I see the results of my select statement.
If I run the dropserver and addserver to rename the instance to the old hostname then enterprise manager and query analyser run fine.
If anyone could tell me what is going on here I would be most appreciative.

Many thanks
Paul

**********************************************************************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
.