Change SQL Instance name to default(local) instrance
- From: "DennisLee" <ddongdog@xxxxxxxxxxxxxxxx>
- Date: Thu, 16 Feb 2006 15:38:57 +0900
I found some information, but, it didn't work.
Now, i open the enterprise manager, and My SQL Server name is
DENNIS\DENNISDB(windows NT), but i want to change this name to default
name(local), when i installed sql, i changed the instance name, i want
default name.
I used this method.
EXEC sp_dropserver 'DENNISDB'
go
EXEC sp_addserver 'DENNIS', 'local'
go
and i restart SQL Server Service and,
SELECT CONVERT(char(20), SERVERPROPERTY('servername'))
result : DENNIS\DENNIDB
select @@SERVERNAME
result : DENNIS
But, stil Instance name On My Enterprize Manager is DENNIS\DENNISDB, I want
"(local)" instance
Help me plase..
.
- Follow-Ups:
- Re: Change SQL Instance name to default(local) instrance
- From: Uri Dimant
- Re: Change SQL Instance name to default(local) instrance
- Prev by Date: Re: Audit log that SA cannot modify
- Next by Date: Re: Change SQL Instance name to default(local) instrance
- Previous by thread: ADO.NET Failed to load msxmlsql.dll
- Next by thread: Re: Change SQL Instance name to default(local) instrance
- Index(es):
Relevant Pages
|
