How to change Name Server/instance?

I've change the computer's name. So my SQLServer doesn't work. Now, How to
change Name Server/instance? So my SQLServer can work again.> I've change the computer's name. So my SQLServer doesn't work. Now, How to
> change Name Server/instance? So my SQLServer can work again.
http://www.karaszi.com/sqlserver/in...server_name.asp
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com|||hi
For this, u need to drop the existing server
sp_dropserver '<old server>'
and add a new server name. do not forget to add the reserved word "local'
sp_addserver '<new server>', 'local'
please let me know if u have any questions
best Regards,
Chandra
http://chanduas.blogspot.com/
http://www.SQLResource.com/
---
"Bpk. Adi Wira Kusuma" wrote:

> I've change the computer's name. So my SQLServer doesn't work. Now, How to
> change Name Server/instance? So my SQLServer can work again.
>
>sql