sql server msde: Hi, I am running SQL Server Personal Edition on a Win2k Pro box, and I need
the server name in Enterprise Mgr toi be something other than (LOCAL), which
is default, can I rename it or do I have any option to reinstall it and give
it a name?
Will MSDE do as much if I need a nerwer product?

Hello,

No need to re install. Go to query analyzer and execute SELECT @@SERVERNAME.
After that go to
enter prise manager and right click above local and unregister. After that
right click above the server and choose register and
in server name give the server name based on the out put of @@Servername.

Incase if the @@servername returns empty or NULL then use SP_ADDSERVER
'Servername','Local' to add a server.
After this you need to stop and start the sql server service.

Thanks
Hari

[quoted text, click to view]