renaming domain

We have a small site where we want to rename the domain and bring it into
our domain.
current names are as
domainx.local -holds SQL server cluster
domainx.net -main domain
we want to bring domainx.local into the domainx.net AD.
will will rename and migrate. Are there any tools for SQL2005?
we were planning on using the microsoft domain rename tool and ADMT3.
Any other issues with SQL?
Regards
CC
SQL itself doesn't really care what domain it is in, as long as all of the
resources and servers it has to access are still accessible the way they
were before. The only thing you will have to update is the windows service
accounts if any of them are from AD and not the local machine. Will it be
renamed or are you moving to a new domain while the old domain remains up
for a short period of time? If the latter I would recommend setting up a
trust and switching the accounts, or understanding that you might have blips
in uptime/availability.
"Ned" <Cal@.obded.org> wrote in message
news:%231UNGh2ZIHA.2000@.TK2MSFTNGP05.phx.gbl...
> We have a small site where we want to rename the domain and bring it into
> our domain.
> current names are as
> domainx.local -holds SQL server cluster
> domainx.net -main domain
> we want to bring domainx.local into the domainx.net AD.
> will will rename and migrate. Are there any tools for SQL2005?
> we were planning on using the microsoft domain rename tool and ADMT3.
> Any other issues with SQL?
> Regards
> CC
>
|||Hi
I assume that the machine names for the SQL Servers are not changing?
If you have granted logins to domain accounts or groups then you may need to
change them see http://support.microsoft.com/kb/298897/
John
"Ned" wrote:

> We have a small site where we want to rename the domain and bring it into
> our domain.
> current names are as
> domainx.local -holds SQL server cluster
> domainx.net -main domain
> we want to bring domainx.local into the domainx.net AD.
> will will rename and migrate. Are there any tools for SQL2005?
> we were planning on using the microsoft domain rename tool and ADMT3.
> Any other issues with SQL?
> Regards
> CC
>
>

renaming domain

We have a small site where we want to rename the domain and bring it into
our domain.
current names are as
domainx.local -holds SQL server cluster
domainx.net -main domain
we want to bring domainx.local into the domainx.net AD.
will will rename and migrate. Are there any tools for SQL2005?
we were planning on using the microsoft domain rename tool and ADMT3.
Any other issues with SQL?
Regards
CCSQL itself doesn't really care what domain it is in, as long as all of the
resources and servers it has to access are still accessible the way they
were before. The only thing you will have to update is the windows service
accounts if any of them are from AD and not the local machine. Will it be
renamed or are you moving to a new domain while the old domain remains up
for a short period of time? If the latter I would recommend setting up a
trust and switching the accounts, or understanding that you might have blips
in uptime/availability.
"Ned" <Cal@.obded.org> wrote in message
news:%231UNGh2ZIHA.2000@.TK2MSFTNGP05.phx.gbl...
> We have a small site where we want to rename the domain and bring it into
> our domain.
> current names are as
> domainx.local -holds SQL server cluster
> domainx.net -main domain
> we want to bring domainx.local into the domainx.net AD.
> will will rename and migrate. Are there any tools for SQL2005?
> we were planning on using the microsoft domain rename tool and ADMT3.
> Any other issues with SQL?
> Regards
> CC
>|||Hi
I assume that the machine names for the SQL Servers are not changing?
If you have granted logins to domain accounts or groups then you may need to
change them see http://support.microsoft.com/kb/298897/
John
"Ned" wrote:
> We have a small site where we want to rename the domain and bring it into
> our domain.
> current names are as
> domainx.local -holds SQL server cluster
> domainx.net -main domain
> we want to bring domainx.local into the domainx.net AD.
> will will rename and migrate. Are there any tools for SQL2005?
> we were planning on using the microsoft domain rename tool and ADMT3.
> Any other issues with SQL?
> Regards
> CC
>
>

Renaming column

ALTER TABLE ISMPBI CHANGE `PBICCGRFNUM` `PBICCGRFNUM1` BIGINT NOT NULL;
this query to rename column name in my sql but not working in sql server
so what is exact syntax to rename columnSee the syntax for the ALTER TABLE command in the online manual (http://msdn2.microsoft.com/en-us/library/ms190273.aspx)

Btw: don't use the backticks. They are a MySQL "speciality" and do not work with any other DBMS (actually they are not needed in MySQL as well)|||MS SQL SERVER does not support RENAME syntax i cant find the syntax to rename column can any one give me exact syntax to rename column|||The ALTER TABLE documentation links to the sp_rename (http://msdn2.microsoft.com/en-us/library/ms188351.aspx) function:
Changes the name of a user-created object in the current database. This object can be a table, index, column, alias data type
Example B: "renaming a column"|||thanks

here is exact syntax

EXEC sp_rename 'BFMENUDEFINITION.[GROUP]', 'MENUGROUP', 'COLUMN';

'BFMENUDEFINITION== tablename

GROUP == old column

'MENUGROUP'== new columnsql

Renaming Analysis DB

Hi

Is it possible to rename an analysis db on analysis services 2000?

Thanks in advance

Thomas

It's been a while since I've messed with 2000, but I do not believe you can change the name. Take a look at the DSO object library to see the the database name can be changed there. If not, then I think you're out of luck.

One solution is to open the AS manager, right-click the database, select copy then paste, and provide a new name. You'll need to reprocess (and possibly remove the old database), but this is how we used to handle this problem.

Good luck,
Bryan

|||

Hi Brian

This works for me. Thank you very much.

Thomas

Renaming an Access table in an SSIS package

My current project requires me to both rename the MDB file for an Access database and rename the table it contains. The Access files comes in with random names, each containing one table with a specific name. Based on the table name it contains, I rename both the file and the interior table to a standard name which a later package in the process references.

A foreach container loops through all the mdb files in the applicable directory, containing a script task and a file system task. The script task uses GetOleDbSchemaTable to extract the table name, then loops through an array of table names from the client's configuration, comparing it to a similar array of constant names and getting the matching one. The file system task then uses that found name (or the original table name if a conversion is not found) to rename the file to match that standard name. So far, so good.

Now I have to rename the table within the file as well. All of the examples of code I'm finding on the 'net refernce ADOX, but I haven't been able to figure out how to use that in a script task, assuming that's what I want to do in the first place.

Anyone have any experience with doing things like this?

Approach 1elect into a new table then drop the old table.

Approach 2: Keep the old "standard" import database and delete from the standard table, then select into it from the new database (that is, instead of renaming the existing object, just select into the desired destination object) then delete/archive the random-named database.

In the past I would have used DAO and the tabledefs collection therein to rename the table, but that is rather old-school these days. No guarantee that it would work.

|||

Thanks, Dylan. I may give the DAO a try just for giggles, because the alternative is (for now) each client having their own copy of a relatively complex package.

Renaming a view

I learned, the hard way, that renaming a view in E.M. doesn't really rename
the view. How can I rename a view without disturbing existing permissions?
thanks,
GThis is a multi-part message in MIME format.
--=_NextPart_000_0240_01C3C884.D985F8E0
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: 7bit
Check out sp_rename in the BOL.
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Gary" <gb@.nospam.com> wrote in message
news:eb#ZuwKyDHA.2452@.tk2msftngp13.phx.gbl...
I learned, the hard way, that renaming a view in E.M. doesn't really rename
the view. How can I rename a view without disturbing existing permissions?
thanks,
G
--=_NextPart_000_0240_01C3C884.D985F8E0
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

Check out sp_rename in the =BOL.
-- Tom
---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"Gary" =wrote in message news:eb#ZuwKyDHA.2452=@.tk2msftngp13.phx.gbl...I learned, the hard way, that renaming a view in E.M. doesn't really =renamethe view. How can I rename a view without disturbing existing permissions?thanks,G

---

--=_NextPart_000_0240_01C3C884.D985F8E0--|||Hi Gary,
Thank you for using MSDN Newsgroup! It's my pleasure to assist you with
your issue.
As our MVP, TOM said, the system sp_rename can change the name of the
view. You can refer to the Books Online for detailed information. The
example code are as follows:
use pubs
go
create view a
as select * from authors
go
exec sp_rename a, b
select * from b
If you still have questions, please feel free to post new message here and
I am ready to help!
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||Hi Baisong
Yes , you are right.
But how do you explain that when I went to EM (after running your script)
selected the desire view and when I opened it by right click on the
properties I still see CREATE VIEW a and NOT b.
"Baisong Wei[MSFT]" <v-baiwei@.online.microsoft.com> wrote in message
news:xCThiKPyDHA.2604@.cpmsftngxa07.phx.gbl...
> Hi Gary,
> Thank you for using MSDN Newsgroup! It's my pleasure to assist you with
> your issue.
> As our MVP, TOM said, the system sp_rename can change the name of the
> view. You can refer to the Books Online for detailed information. The
> example code are as follows:
> use pubs
> go
> create view a
> as select * from authors
> go
> exec sp_rename a, b
> select * from b
> If you still have questions, please feel free to post new message here and
> I am ready to help!
>
> Best regards
> Baisong Wei
> Microsoft Online Support
> ----
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only. Thanks.
>
>|||Hi Gary,
Thank you for using MSDN Newsgroup! It's my pleasure to assist you with
your issue.
Your prudential is really impressive. You even notice some detailed
information of our pruduct. Here is my explanation to these.
When a view is created, the name of the view is stored in the sysobjects
table. Information about the columns defined in a view is added to the
syscolumns table, and information about the view dependencies is added to
the sysdepends table. In addition, the text of the CREATE VIEW statement is
added to the syscomments table.
use pubs
SELECT text FROM syscomments WHERE id = object_id('b')
you will get 'create view a as select * from authors'.
However, this is just a comment of this object, that is view 'b' , the
object name is saved in sysobjects and the definition of it is 'select *
from authors'. When using the 'sp_rename', it will not change the content
of the syscomments. This will not affect any application of this view. It
just because to keep the high performance of the system SPs.
If you still have questions, please feel free to post new message here and
I am ready to help!
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.sql

Renaming a Table

Is there a way to rename a table in a database without breaking all the
relationships, views etc.?
Is there any procedure which would search the DB for references to the old
table name and change them to the new one?
ThanksTo display recorded dependencies you can use sp_depends. This may not list
everything though. To be sure, you could use EM to generate a script of all
objects in the database and then do a textual search on the script. An an
interim measure, you could rename the table then create a view with the old
tablename as its name which does a select * from the new tablename, while
you point the other objects towards the new table.
HTH,
Paul Ibison

renaming a table

I know you can rename a table using sp_rename, but what I'm not sure about i
s
how to specify which database.
I'm doing this in VB (or in C#, it doesn't matter).
I have a connection to the SQL Server.
I can Exec sp_rename and give it oldname and newname for the table, but how
am I making sure it's for a table within a particular database?Try:
exec MyDB.dbo.sp_rename 'MyTable', 'MyNewTable'
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada tom@.cips.ca
www.pinpub.com
"Les Stockton" <LesStockton@.discussions.microsoft.com> wrote in message
news:7E260686-7AA8-49AF-A674-7F2073B35ABC@.microsoft.com...
>I know you can rename a table using sp_rename, but what I'm not sure about
>is
> how to specify which database.
> I'm doing this in VB (or in C#, it doesn't matter).
> I have a connection to the SQL Server.
> I can Exec sp_rename and give it oldname and newname for the table, but
> how
> am I making sure it's for a table within a particular database?|||Les,
The activity will take place in the database you are connected to. Client
interfaces allow you to specify the database (catalog) you are connected to.
Or, you could achieve this with T-SQL:
USE database_name;
EXEC sp_rename ...
Unfortunately, sp_rename doesn't allow you to specify the database name,
rather it will run in the context of the "current" database.
BG, SQL Server MVP
www.SolidQualityLearning.com
"Les Stockton" <LesStockton@.discussions.microsoft.com> wrote in message
news:7E260686-7AA8-49AF-A674-7F2073B35ABC@.microsoft.com...
>I know you can rename a table using sp_rename, but what I'm not sure about
>is
> how to specify which database.
> I'm doing this in VB (or in C#, it doesn't matter).
> I have a connection to the SQL Server.
> I can Exec sp_rename and give it oldname and newname for the table, but
> how
> am I making sure it's for a table within a particular database?

renaming a table

how do i rename a table? i tried making a copy of it (select * into copy from original), but it turns out that doesn't work either... =(The method for renaming objects depends on which database engine you are using.

-PatP|||In SQL 2000
Select * into newTable from OldTable
drop Table OldTable

Madhivanan|||in sql serversp_rename 'tablename' , 'newname'

Renaming a Table

Is there a way to rename a table in a database without breaking all the
relationships, views etc.?
Is there any procedure which would search the DB for references to the old
table name and change them to the new one?
Thanks
To display recorded dependencies you can use sp_depends. This may not list
everything though. To be sure, you could use EM to generate a script of all
objects in the database and then do a textual search on the script. An an
interim measure, you could rename the table then create a view with the old
tablename as its name which does a select * from the new tablename, while
you point the other objects towards the new table.
HTH,
Paul Ibison
sql

Renaming a Table

Is there a way to rename a table in a database without breaking all the
relationships, views etc.?
Is there any procedure which would search the DB for references to the old
table name and change them to the new one?
ThanksTo display recorded dependencies you can use sp_depends. This may not list
everything though. To be sure, you could use EM to generate a script of all
objects in the database and then do a textual search on the script. An an
interim measure, you could rename the table then create a view with the old
tablename as its name which does a select * from the new tablename, while
you point the other objects towards the new table.
HTH,
Paul Ibison|||check out www.dbghost.com
>--Original Message--
>Is there a way to rename a table in a database without
breaking all the
>relationships, views etc.?
>Is there any procedure which would search the DB for
references to the old
>table name and change them to the new one?
>Thanks
>
>.
>

Renaming a sql server instance after you rename the server

I installed sql server on one of my test servers, and I am eventually going to rename this server and put it into production. This server will replace one of my old servers with the same name. I was wondering if there was a way to rename the SQL Server instance after you rename your server without having to reinstall SQL Server. Thanks in advance for all the help.Originally posted by svanati
I installed sql server on one of my test servers, and I am eventually going to rename this server and put it into production. This server will replace one of my old servers with the same name. I was wondering if there was a way to rename the SQL Server instance after you rename your server without having to reinstall SQL Server. Thanks in advance for all the help.

Done this many times. If you are using replication it gets more complex. I've done that as well but I will assume you aren't

Accommodate change in NetBIOS name:

sp_dropserver 'oldname', 'droplogins'
sp_addserver 'newname', local

use msdb
go
SELECT * FROM sysjobs -- Check which jobs have which server name...
update sysjobs set originating_server = 'newname' -- Assumes no jobs intentionally use a different server name

restart SQL Server

SELECT @.@.servername -- The result should match the systems NetBIOS name|||Thanks for the help.sql

Renaming a SQL Cluster

Can anyone tell me if it's possible to rename a cluster?
Fro example, we have an Active/Passive cluster made up of two servers.
'Server1' and 'Server2' which make up the cluster 'Cluster1' is it
possible to rename this to 'Cluster2' without affecting the servers that
make it up?
Thanks
*** Sent via Developersdex http://www.codecomments.com ***
Yes, you can rename the cluster. You can't rename SQL Instances though.
Start Cluster Administrator from the Cluster Group Controlling node - use a
"." as the cluster name.
Take the Cluster Group Offline.
Double click on the Network Name resource and change the parameters
information.
Bring the Cluster Group Online.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
"Dave" <Anonymous@.devdex.com> wrote in message
news:O$m1e2McFHA.3184@.TK2MSFTNGP15.phx.gbl...
> Can anyone tell me if it's possible to rename a cluster?
> Fro example, we have an Active/Passive cluster made up of two servers.
> 'Server1' and 'Server2' which make up the cluster 'Cluster1' is it
> possible to rename this to 'Cluster2' without affecting the servers that
> make it up?
> Thanks
>
>
> *** Sent via Developersdex http://www.codecomments.com ***

Renaming a server with SQL 2000 installed

Does anyone know if there would be any issue with SQL if I rename my server?
What complications could this cause?
If you rename the server, SQL Server won't continue to work until you rename
the SQL Server .... which is done by re-installing SQL Server.
Robert
"Wade" wrote:

> Does anyone know if there would be any issue with SQL if I rename my server?
> What complications could this cause?
|||Reinstalling is not required. The things that might break
include replication, linked servers and master jobs. To
reset the relevant row in master..sysservers use:
Use Master
go
Sp_DropServer 'OldName'
GO
Use Master
go
Sp_Addserver 'NewName', 'local'
GO
Stop and Start SQL Services
At this stage, select @.@.SERVERNAME and select
SERVERPROPERTY('ServerName') should give the same value.
HTH,
Paul Ibison (SQL Server MVP)
|||Thanks for you help!
"Paul Ibison" wrote:

> Reinstalling is not required. The things that might break
> include replication, linked servers and master jobs. To
> reset the relevant row in master..sysservers use:
> Use Master
> go
> Sp_DropServer 'OldName'
> GO
> Use Master
> go
> Sp_Addserver 'NewName', 'local'
> GO
> Stop and Start SQL Services
> At this stage, select @.@.SERVERNAME and select
> SERVERPROPERTY('ServerName') should give the same value.
> HTH,
> Paul Ibison (SQL Server MVP)
>

Renaming a server with SQL 2000 installed

Does anyone know if there would be any issue with SQL if I rename my server?
What complications could this cause?If you rename the server, SQL Server won't continue to work until you rename
the SQL Server .... which is done by re-installing SQL Server.
Robert
"Wade" wrote:
> Does anyone know if there would be any issue with SQL if I rename my server?
> What complications could this cause?|||Reinstalling is not required. The things that might break
include replication, linked servers and master jobs. To
reset the relevant row in master..sysservers use:
Use Master
go
Sp_DropServer 'OldName'
GO
Use Master
go
Sp_Addserver 'NewName', 'local'
GO
Stop and Start SQL Services
At this stage, select @.@.SERVERNAME and select
SERVERPROPERTY('ServerName') should give the same value.
HTH,
Paul Ibison (SQL Server MVP)|||Thanks for you help!
"Paul Ibison" wrote:
> Reinstalling is not required. The things that might break
> include replication, linked servers and master jobs. To
> reset the relevant row in master..sysservers use:
> Use Master
> go
> Sp_DropServer 'OldName'
> GO
> Use Master
> go
> Sp_Addserver 'NewName', 'local'
> GO
> Stop and Start SQL Services
> At this stage, select @.@.SERVERNAME and select
> SERVERPROPERTY('ServerName') should give the same value.
> HTH,
> Paul Ibison (SQL Server MVP)
>

Renaming a named SQL Server 2000 instance

Guys
I am trying to rename a named SQL Server instance , please share any inputs
Thanks
SwamiNo can do. Install a new instance with desired name and transfer the data (b
ackup/restore,
detach/attach, DTS etc...).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Swami" <Swami@.discussions.microsoft.com> wrote in message
news:BD8C5C3D-15D0-447F-AB0D-78AB8B7D8F1B@.microsoft.com...
> Guys
> I am trying to rename a named SQL Server instance , please share any inpu
ts
> Thanks
> Swami|||Hi,
Only default instance of sql server can be renamed. As Tibor mentioned only
way to change the named instance is by doing new Named instance with
required name and then transfer all databases from old instance to new
installed instance.
Thanks
Hari
SQL Server MVP
"Swami" <Swami@.discussions.microsoft.com> wrote in message
news:BD8C5C3D-15D0-447F-AB0D-78AB8B7D8F1B@.microsoft.com...
> Guys
> I am trying to rename a named SQL Server instance , please share any
> inputs
> Thanks
> Swami

Renaming a named SQL Server 2000 instance

Guys
I am trying to rename a named SQL Server instance , please share any inputs
Thanks
Swami
No can do. Install a new instance with desired name and transfer the data (backup/restore,
detach/attach, DTS etc...).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Swami" <Swami@.discussions.microsoft.com> wrote in message
news:BD8C5C3D-15D0-447F-AB0D-78AB8B7D8F1B@.microsoft.com...
> Guys
> I am trying to rename a named SQL Server instance , please share any inputs
> Thanks
> Swami
|||Hi,
Only default instance of sql server can be renamed. As Tibor mentioned only
way to change the named instance is by doing new Named instance with
required name and then transfer all databases from old instance to new
installed instance.
Thanks
Hari
SQL Server MVP
"Swami" <Swami@.discussions.microsoft.com> wrote in message
news:BD8C5C3D-15D0-447F-AB0D-78AB8B7D8F1B@.microsoft.com...
> Guys
> I am trying to rename a named SQL Server instance , please share any
> inputs
> Thanks
> Swami
sql

Renaming a named SQL Server 2000 instance

Guys
I am trying to rename a named SQL Server instance , please share any inputs
Thanks
SwamiHi Swami,
Try something like this:
sp_dropserver <old_servername\instancename>
go
sp_addserver <new_servername\instancename> , local
go
Good luck
Regards,
Dilip|||No can do. Install a new instance with desired name and transfer the data (backup/restore,
detach/attach, DTS etc...).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Swami" <Swami@.discussions.microsoft.com> wrote in message
news:BD8C5C3D-15D0-447F-AB0D-78AB8B7D8F1B@.microsoft.com...
> Guys
> I am trying to rename a named SQL Server instance , please share any inputs
> Thanks
> Swami|||Hi,
Only default instance of sql server can be renamed. As Tibor mentioned only
way to change the named instance is by doing new Named instance with
required name and then transfer all databases from old instance to new
installed instance.
Thanks
Hari
SQL Server MVP
"Swami" <Swami@.discussions.microsoft.com> wrote in message
news:BD8C5C3D-15D0-447F-AB0D-78AB8B7D8F1B@.microsoft.com...
> Guys
> I am trying to rename a named SQL Server instance , please share any
> inputs
> Thanks
> Swami

Renaming a named instance of SQL Server 2005

I installed a named instance of SQL Server 2005 on a machine...let's
say I called it VAIO4. I want to rename it to BTSERVER. I'd rather not
have to uninstall and reinstall, but will do that if I have to. Is
there a way to rename the named instance without uninstall/reinstall?Unfortunately, you'll have to do the de-install/reinstall thing.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
<broy@.omegasoftwareinc.com> wrote in message
news:1150329868.510319.124590@.p79g2000cwp.googlegroups.com...
I installed a named instance of SQL Server 2005 on a machine...let's
say I called it VAIO4. I want to rename it to BTSERVER. I'd rather not
have to uninstall and reinstall, but will do that if I have to. Is
there a way to rename the named instance without uninstall/reinstall?|||Thanks Tom...
Just FMI, wasn't this something that could be done in SQL Server 2000
without uninstall/reinstall? Did the capability disappear with SQL
Server 2005 or was it never there even in 2000?|||I don't recall it being a possibility with 2000. However, it's been on my
wish list for a good long time. Don't get me started... ;-)
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
<broy@.omegasoftwareinc.com> wrote in message
news:1150334059.199056.4380@.h76g2000cwa.googlegroups.com...
Thanks Tom...
Just FMI, wasn't this something that could be done in SQL Server 2000
without uninstall/reinstall? Did the capability disappear with SQL
Server 2005 or was it never there even in 2000?|||OK, OK, won't get you started (or did I already?!). Just another quick
question for you, though. What if want another named instance of SQL
Server 2005 on the machine. Do I need to go through another install to
do that or is there another way to "spawn" another named instance on
the machine without getting rid of the current one?|||Nope, you gotta do one install per instance. Kinda makes sense, since each
instance could be a different version or different Service Pack level.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
<broy@.omegasoftwareinc.com> wrote in message
news:1150336619.432501.214330@.h76g2000cwa.googlegroups.com...
OK, OK, won't get you started (or did I already?!). Just another quick
question for you, though. What if want another named instance of SQL
Server 2005 on the machine. Do I need to go through another install to
do that or is there another way to "spawn" another named instance on
the machine without getting rid of the current one?|||it's actually possible. (WARNING: do at your own perils!)
1. drop current instname (sp_dropserver)
2. add new instance name (sp_addserver 'new name','local')
3. stop sqlserver
4. modify hklm\software\microsoft\microsoft sql server\
5. modify hklm\system\mssql$<instance>
6. use "sc create" to add new mssql$<inst>
7. start up with new inst_name - voila!
-oj
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23eYqXqBkGHA.2200@.TK2MSFTNGP05.phx.gbl...
>I don't recall it being a possibility with 2000. However, it's been on my
> wish list for a good long time. Don't get me started... ;-)
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> <broy@.omegasoftwareinc.com> wrote in message
> news:1150334059.199056.4380@.h76g2000cwa.googlegroups.com...
> Thanks Tom...
> Just FMI, wasn't this something that could be done in SQL Server 2000
> without uninstall/reinstall? Did the capability disappear with SQL
> Server 2005 or was it never there even in 2000?
>|||oops. #5 should be "modify
hklm\system\currentcontrolset\services\mssql$inst"
--
-oj
"oj" <nospam_ojngo@.home.com> wrote in message
news:elptQuCkGHA.1276@.TK2MSFTNGP03.phx.gbl...
> it's actually possible. (WARNING: do at your own perils!)
> 1. drop current instname (sp_dropserver)
> 2. add new instance name (sp_addserver 'new name','local')
> 3. stop sqlserver
> 4. modify hklm\software\microsoft\microsoft sql server\
> 5. modify hklm\system\mssql$<instance>
> 6. use "sc create" to add new mssql$<inst>
> 7. start up with new inst_name - voila!
>
> --
> -oj
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:%23eYqXqBkGHA.2200@.TK2MSFTNGP05.phx.gbl...
>>I don't recall it being a possibility with 2000. However, it's been on my
>> wish list for a good long time. Don't get me started... ;-)
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Toronto, ON Canada
>> .
>> <broy@.omegasoftwareinc.com> wrote in message
>> news:1150334059.199056.4380@.h76g2000cwa.googlegroups.com...
>> Thanks Tom...
>> Just FMI, wasn't this something that could be done in SQL Server 2000
>> without uninstall/reinstall? Did the capability disappear with SQL
>> Server 2005 or was it never there even in 2000?
>|||The problem is that 'do at your own perils!' How does one know that all the
references to the old instance name have been changed everywhere?
Linchi
"oj" wrote:
> it's actually possible. (WARNING: do at your own perils!)
> 1. drop current instname (sp_dropserver)
> 2. add new instance name (sp_addserver 'new name','local')
> 3. stop sqlserver
> 4. modify hklm\software\microsoft\microsoft sql server\
> 5. modify hklm\system\mssql$<instance>
> 6. use "sc create" to add new mssql$<inst>
> 7. start up with new inst_name - voila!
>
> --
> -oj
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:%23eYqXqBkGHA.2200@.TK2MSFTNGP05.phx.gbl...
> >I don't recall it being a possibility with 2000. However, it's been on my
> > wish list for a good long time. Don't get me started... ;-)
> >
> > --
> > Tom
> >
> > ----
> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> > SQL Server MVP
> > Toronto, ON Canada
> > .
> > <broy@.omegasoftwareinc.com> wrote in message
> > news:1150334059.199056.4380@.h76g2000cwa.googlegroups.com...
> > Thanks Tom...
> >
> > Just FMI, wasn't this something that could be done in SQL Server 2000
> > without uninstall/reinstall? Did the capability disappear with SQL
> > Server 2005 or was it never there even in 2000?
> >
>
>|||"do at your own perils" is just my blanket disclaimer when it comes to
system configuration. Actually, you can do all this very safely. Instead of
modifying the existing keys, you can create a new set. Modify this new set
with appropriate changes (I'll see about putting an article together
documenting it all). Register a new service for the new instance and then
start it.
Your original configuration/data is _never_ touched, so, if need to, you can
always start up the old instance.
--
-oj
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:97130750-F0A3-483C-8693-BAD70E02F5CF@.microsoft.com...
> The problem is that 'do at your own perils!' How does one know that all
> the
> references to the old instance name have been changed everywhere?
> Linchi
> "oj" wrote:
>> it's actually possible. (WARNING: do at your own perils!)
>> 1. drop current instname (sp_dropserver)
>> 2. add new instance name (sp_addserver 'new name','local')
>> 3. stop sqlserver
>> 4. modify hklm\software\microsoft\microsoft sql server\
>> 5. modify hklm\system\mssql$<instance>
>> 6. use "sc create" to add new mssql$<inst>
>> 7. start up with new inst_name - voila!
>>
>> --
>> -oj
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23eYqXqBkGHA.2200@.TK2MSFTNGP05.phx.gbl...
>> >I don't recall it being a possibility with 2000. However, it's been on
>> >my
>> > wish list for a good long time. Don't get me started... ;-)
>> >
>> > --
>> > Tom
>> >
>> > ----
>> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> > SQL Server MVP
>> > Toronto, ON Canada
>> > .
>> > <broy@.omegasoftwareinc.com> wrote in message
>> > news:1150334059.199056.4380@.h76g2000cwa.googlegroups.com...
>> > Thanks Tom...
>> >
>> > Just FMI, wasn't this something that could be done in SQL Server 2000
>> > without uninstall/reinstall? Did the capability disappear with SQL
>> > Server 2005 or was it never there even in 2000?
>> >
>>|||Makes you wonder why MS doesn't have a tool to do this - without the risk or
disclaimer. I think many folks would sure love to have it.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"oj" <nospam_ojngo@.home.com> wrote in message
news:O%23dBhbKkGHA.3484@.TK2MSFTNGP03.phx.gbl...
"do at your own perils" is just my blanket disclaimer when it comes to
system configuration. Actually, you can do all this very safely. Instead of
modifying the existing keys, you can create a new set. Modify this new set
with appropriate changes (I'll see about putting an article together
documenting it all). Register a new service for the new instance and then
start it.
Your original configuration/data is _never_ touched, so, if need to, you can
always start up the old instance.
--
-oj
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:97130750-F0A3-483C-8693-BAD70E02F5CF@.microsoft.com...
> The problem is that 'do at your own perils!' How does one know that all
> the
> references to the old instance name have been changed everywhere?
> Linchi
> "oj" wrote:
>> it's actually possible. (WARNING: do at your own perils!)
>> 1. drop current instname (sp_dropserver)
>> 2. add new instance name (sp_addserver 'new name','local')
>> 3. stop sqlserver
>> 4. modify hklm\software\microsoft\microsoft sql server\
>> 5. modify hklm\system\mssql$<instance>
>> 6. use "sc create" to add new mssql$<inst>
>> 7. start up with new inst_name - voila!
>>
>> --
>> -oj
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23eYqXqBkGHA.2200@.TK2MSFTNGP05.phx.gbl...
>> >I don't recall it being a possibility with 2000. However, it's been on
>> >my
>> > wish list for a good long time. Don't get me started... ;-)
>> >
>> > --
>> > Tom
>> >
>> > ----
>> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> > SQL Server MVP
>> > Toronto, ON Canada
>> > .
>> > <broy@.omegasoftwareinc.com> wrote in message
>> > news:1150334059.199056.4380@.h76g2000cwa.googlegroups.com...
>> > Thanks Tom...
>> >
>> > Just FMI, wasn't this something that could be done in SQL Server 2000
>> > without uninstall/reinstall? Did the capability disappear with SQL
>> > Server 2005 or was it never there even in 2000?
>> >
>>|||well, it's not that simple. ;-)
you can't easily change instance name if you have replication, loopback
linked server, etc. which depends on the old instance name. also, it would
be more support call for them because the new instance name does not
reference the normal instance path (i.e. physical location/pointer still
point to the old instance). this can be very confusing for _regular_ users.
uninstall/reinstall is the recommended route because it ensures everything
is right where it should be. of course this requires some work on the dba
(i.e. move data from old instance to new instance) but that's not of their
concern.
-oj
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OY4F5FNkGHA.456@.TK2MSFTNGP05.phx.gbl...
> Makes you wonder why MS doesn't have a tool to do this - without the risk
> or
> disclaimer. I think many folks would sure love to have it.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "oj" <nospam_ojngo@.home.com> wrote in message
> news:O%23dBhbKkGHA.3484@.TK2MSFTNGP03.phx.gbl...
> "do at your own perils" is just my blanket disclaimer when it comes to
> system configuration. Actually, you can do all this very safely. Instead
> of
> modifying the existing keys, you can create a new set. Modify this new set
> with appropriate changes (I'll see about putting an article together
> documenting it all). Register a new service for the new instance and then
> start it.
> Your original configuration/data is _never_ touched, so, if need to, you
> can
> always start up the old instance.
> --
> -oj
>
> "Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
> news:97130750-F0A3-483C-8693-BAD70E02F5CF@.microsoft.com...
>> The problem is that 'do at your own perils!' How does one know that all
>> the
>> references to the old instance name have been changed everywhere?
>> Linchi
>> "oj" wrote:
>> it's actually possible. (WARNING: do at your own perils!)
>> 1. drop current instname (sp_dropserver)
>> 2. add new instance name (sp_addserver 'new name','local')
>> 3. stop sqlserver
>> 4. modify hklm\software\microsoft\microsoft sql server\
>> 5. modify hklm\system\mssql$<instance>
>> 6. use "sc create" to add new mssql$<inst>
>> 7. start up with new inst_name - voila!
>>
>> --
>> -oj
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23eYqXqBkGHA.2200@.TK2MSFTNGP05.phx.gbl...
>> >I don't recall it being a possibility with 2000. However, it's been on
>> >my
>> > wish list for a good long time. Don't get me started... ;-)
>> >
>> > --
>> > Tom
>> >
>> > ----
>> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> > SQL Server MVP
>> > Toronto, ON Canada
>> > .
>> > <broy@.omegasoftwareinc.com> wrote in message
>> > news:1150334059.199056.4380@.h76g2000cwa.googlegroups.com...
>> > Thanks Tom...
>> >
>> > Just FMI, wasn't this something that could be done in SQL Server 2000
>> > without uninstall/reinstall? Did the capability disappear with SQL
>> > Server 2005 or was it never there even in 2000?
>> >
>>
>

Renaming a named instance of SQL Server 2005

I installed a named instance of SQL Server 2005 on a machine...let's
say I called it VAIO4. I want to rename it to BTSERVER. I'd rather not
have to uninstall and reinstall, but will do that if I have to. Is
there a way to rename the named instance without uninstall/reinstall?Unfortunately, you'll have to do the de-install/reinstall thing.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
<broy@.omegasoftwareinc.com> wrote in message
news:1150329868.510319.124590@.p79g2000cwp.googlegroups.com...
I installed a named instance of SQL Server 2005 on a machine...let's
say I called it VAIO4. I want to rename it to BTSERVER. I'd rather not
have to uninstall and reinstall, but will do that if I have to. Is
there a way to rename the named instance without uninstall/reinstall?|||Thanks Tom...
Just FMI, wasn't this something that could be done in SQL Server 2000
without uninstall/reinstall? Did the capability disappear with SQL
Server 2005 or was it never there even in 2000?|||I don't recall it being a possibility with 2000. However, it's been on my
wish list for a good long time. Don't get me started... ;-)
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
<broy@.omegasoftwareinc.com> wrote in message
news:1150334059.199056.4380@.h76g2000cwa.googlegroups.com...
Thanks Tom...
Just FMI, wasn't this something that could be done in SQL Server 2000
without uninstall/reinstall? Did the capability disappear with SQL
Server 2005 or was it never there even in 2000?|||OK, OK, won't get you started (or did I already?!). Just another quick
question for you, though. What if want another named instance of SQL
Server 2005 on the machine. Do I need to go through another install to
do that or is there another way to "spawn" another named instance on
the machine without getting rid of the current one?|||Nope, you gotta do one install per instance. Kinda makes sense, since each
instance could be a different version or different Service Pack level.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
<broy@.omegasoftwareinc.com> wrote in message
news:1150336619.432501.214330@.h76g2000cwa.googlegroups.com...
OK, OK, won't get you started (or did I already?!). Just another quick
question for you, though. What if want another named instance of SQL
Server 2005 on the machine. Do I need to go through another install to
do that or is there another way to "spawn" another named instance on
the machine without getting rid of the current one?|||it's actually possible. (WARNING: do at your own perils!)
1. drop current instname (sp_dropserver)
2. add new instance name (sp_addserver 'new name','local')
3. stop sqlserver
4. modify hklm\software\microsoft\microsoft sql server\
5. modify hklm\system\mssql$<instance>
6. use "sc create" to add new mssql$<inst>
7. start up with new inst_name - voila!
-oj
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23eYqXqBkGHA.2200@.TK2MSFTNGP05.phx.gbl...
>I don't recall it being a possibility with 2000. However, it's been on my
> wish list for a good long time. Don't get me started... ;-)
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> <broy@.omegasoftwareinc.com> wrote in message
> news:1150334059.199056.4380@.h76g2000cwa.googlegroups.com...
> Thanks Tom...
> Just FMI, wasn't this something that could be done in SQL Server 2000
> without uninstall/reinstall? Did the capability disappear with SQL
> Server 2005 or was it never there even in 2000?
>|||oops. #5 should be "modify
hklm\system\currentcontrolset\services\m
ssql$inst"
-oj
"oj" <nospam_ojngo@.home.com> wrote in message
news:elptQuCkGHA.1276@.TK2MSFTNGP03.phx.gbl...
> it's actually possible. (WARNING: do at your own perils!)
> 1. drop current instname (sp_dropserver)
> 2. add new instance name (sp_addserver 'new name','local')
> 3. stop sqlserver
> 4. modify hklm\software\microsoft\microsoft sql server\
> 5. modify hklm\system\mssql$<instance>
> 6. use "sc create" to add new mssql$<inst>
> 7. start up with new inst_name - voila!
>
> --
> -oj
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:%23eYqXqBkGHA.2200@.TK2MSFTNGP05.phx.gbl...
>|||Unfortunately, you'll have to do the de-install/reinstall thing.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
<broy@.omegasoftwareinc.com> wrote in message
news:1150329868.510319.124590@.p79g2000cwp.googlegroups.com...
I installed a named instance of SQL Server 2005 on a machine...let's
say I called it VAIO4. I want to rename it to BTSERVER. I'd rather not
have to uninstall and reinstall, but will do that if I have to. Is
there a way to rename the named instance without uninstall/reinstall?|||Thanks Tom...
Just FMI, wasn't this something that could be done in SQL Server 2000
without uninstall/reinstall? Did the capability disappear with SQL
Server 2005 or was it never there even in 2000?