Hi
I have a quick question about renaming an instance.
I used sp_dropserver and dropped the instance name
I used sp_addserver '<servername>, 'local' and changed the local instance
name.
After stopping and restarting the instance, i was able to connect to the new
instance name.
But i can still connect using the old instance name also.
I want to drop the old instance name completely.
How do i do that?
--UdaySee question number 5 in:
Frequently asked questions - SQL Server 2000 - multiple instances
http://support.microsoft.com/newsgroups/default.aspx
AMB
"Udayasree" wrote:
> Hi
> I have a quick question about renaming an instance.
> I used sp_dropserver and dropped the instance name
> I used sp_addserver '<servername>, 'local' and changed the local instance
> name.
> After stopping and restarting the instance, i was able to connect to the n
ew
> instance name.
> But i can still connect using the old instance name also.
> I want to drop the old instance name completely.
> How do i do that?
> --Uday
Friday, February 10, 2012
Chaning an Instance name
Labels:
chaning,
database,
dropped,
hii,
instance,
ltservernamegt,
microsoft,
mysql,
namei,
oracle,
renaming,
server,
sp_addserver,
sp_dropserver,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment