did you do

sp_dropserver 'old name'
sp_addserver 'new name', 'local'

reboot


Also script out your jobs and look in there fore the name of your old
server.
change it and reapply your jobs.



--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Alfredo Ramirez" <aramirez (AT) heico (DOT) com> wrote

Thank you for getting back to me so soon.

I tried to drop the server and here is the error message:

Server: Msg 15015, Level 16, State 1, Procedure sp_dropserver, Line 28
The server 'hei_prt2' does not exist. Use sp_helpserver to show
available servers.

When I use the sp_helpserver command the only name that is return is the
new name.

Do you have any other suggestions?

Thank you

Alfredo Ramirez

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!