Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Rename SQL

Author  Topic 

TRACEYSQL
Aged Yak Warrior

594 Posts

Posted - 2006-08-10 : 14:23:09
Right now when i go into EM i have SQLDEV ...as the name

I need to change this to FINANCESQLDEV

The machine is called SQLDEV

If i rename my machine as FINANCESQLDEV...how to i get the SQL EM to use FINANCESQLDEV
instead of SQLDEV

Do i have to run a command in SQL at all..

Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-08-10 : 14:31:21
You can simply un-register the server then re-register it with the new name.

You'll need to check out the article in BOL that describes what you need to do to SQL Server when you rename the server.

Tara Kizer
Go to Top of Page
   

- Advertisement -