Tommy Bollhofer (2/19/2008)
After renaming the Windows server, issue a sp_dropserver, sp_addserver and restart MSSQL services.
use master
go
exec sp_dropserver 'old server name'
go
sp_addserver 'new server name', 'local'
go
Just be aware that your current jobs may not function because of changing the server's name you can verify it with this query
SELECT *
FROM msdb..sysjobs
"-=Still Learning=-"
Lester Policarpio