How to change the instance name?

Hello DBA's

I have installed SQL Server 2005 on a machine with named instance, but later I noticed that I created it with the wrong name than desired. Now I need to change the instace name of the SQL Server that I have installed. How can I do that

Thanks

Satya

There is not a supported way to rename an instance. You need to uninstall and then reinstall.

Thanks,

Peter Saddow

|||

Thanks Peter

Satya

How to change the default backup data directory in SQL Server 2000?

Hi,

I had SQL Server 2000 installed like below:

Installation Directory = C:\Program Files\Microsoft SQL Server

Default data directory = D:\

Default log directory = D:\

I found out that the data is stored in D:\Program Files\Microsoft SQL Server\MSSQL\data and backup is done in D:\Program Files\Microsoft SQL Server\MSSQL\backup

However, Microsoft says we should never put the ..\backup and ..\data folders in the same partition.

My question is: How can I move the path of the backup directory?

I checked the registy but this is what I found:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer

..BackupDirectory=C:\Program Files\Microsoft SQL Server\MSSQL\backup (<-- note it is pointing to C:\ not D:\)

..DefaultData=D:\

Can somebody help please?

http://search.msn.com/results.aspx?q=Introduction+to+Microsoft+SQL+Server%e2%84%a2+2000+Reporting+Services

Beneficial or non-beneficial link above

http://support.microsoft.com/kb/185663/

|||

Hi,

As you reach to the correct part change the values of .BackupDirectory=<pathyouwanttoSoreBackUp>

or/and if you are using Schedule/Maintanance Plan you may specify the path their too.

Hemantgiri S. Goswami

How to change SQL Server 2005 Server side Collaction?

How to change SQL Server 2005 Server side Collaction?
As the previous staff installed SQL Server 2005 using invalid collaction,
now, We want to change the server side collaction to correct one. How
should I do?In SQL Server 2005 there's a new way of doing this. Please have a look at
"To rebuild system databases and specify a new system collation" in
http://msdn2.microsoft.com/en-us/library/ms144259.aspx
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

How to change SQL Server 2005 Server side Collaction?

How to change SQL Server 2005 Server side Collaction?
As the previous staff installed SQL Server 2005 using invalid collaction,
now, We want to change the server side collaction to correct one. How
should I do?In SQL Server 2005 there's a new way of doing this. Please have a look at
"To rebuild system databases and specify a new system collation" in
http://msdn2.microsoft.com/en-us/library/ms144259.aspx
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

How to change SQL Server 2005 Server side Collaction?

How to change SQL Server 2005 Server side Collaction?
As the previous staff installed SQL Server 2005 using invalid collaction,
now, We want to change the server side collaction to correct one. How
should I do?
In SQL Server 2005 there's a new way of doing this. Please have a look at
"To rebuild system databases and specify a new system collation" in
http://msdn2.microsoft.com/en-us/library/ms144259.aspx
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

How to change SQL Server 2005 instance name

Hi,
I have installed SQL Server 2005 Express Edition on my system. The default instance name is set as SQLEXPRESS. I want to change this to something else. Is there anyway I can do that?
Thanks,
pravi

Hi Pravi,

here is a reference material for renaming a Server / Instance

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_afterinstall_5r8f.asp

HTH

Hemantgiri S. Goswami

|||

hi Pravi,

named instances can not be renamed...

regards

How to change SA Password?

Hi, i'm running SQL Server 2000, the SA password hasn't been changed since it was installed. How do i go aobut changing the SA password? thanks in advice to any one who can help.Use EM - you'll find it under Security / Logins.

how to change licensing modes

I installed SQL 2K on a per user basis and now want to change that to a per
processor licensing mode. Cant seem to do that change from Control Panel and
do now wish to reinstall .. Is there a way ?http://www.tkdinesh.com/faq/ans/license.html
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:#szsZX#pDHA.1496@.TK2MSFTNGP11.phx.gbl...
> I installed SQL 2K on a per user basis and now want to change that to a
per
> processor licensing mode. Cant seem to do that change from Control Panel
and
> do now wish to reinstall .. Is there a way ?
>

How to change license type from Per Proc to CAL ?

We had a production server installed with a Per Processor license by mistake
and need to change it to 'per seat' ie CAL. Is there a way to do this without
reinstalling SQL on the server (as it is a production server now) ? The
'Choose Licensing Mode' in control panel has the 'per seat' option grayed out
and only allows to change the number of processor licenses.
Thanks.Hi
"Pranil" wrote:
> We had a production server installed with a Per Processor license by mistake
> and need to change it to 'per seat' ie CAL. Is there a way to do this without
> reinstalling SQL on the server (as it is a production server now) ? The
> 'Choose Licensing Mode' in control panel has the 'per seat' option grayed out
> and only allows to change the number of processor licenses.
> Thanks.
With a production server it is better to be safe as downtime could be
costly, but you could try http://tinyurl.com/25rvyo
John|||Awesome - thanks!
"John Bell" wrote:
> Hi
> "Pranil" wrote:
> > We had a production server installed with a Per Processor license by mistake
> > and need to change it to 'per seat' ie CAL. Is there a way to do this without
> > reinstalling SQL on the server (as it is a production server now) ? The
> > 'Choose Licensing Mode' in control panel has the 'per seat' option grayed out
> > and only allows to change the number of processor licenses.
> >
> > Thanks.
> With a production server it is better to be safe as downtime could be
> costly, but you could try http://tinyurl.com/25rvyo
> John

How to change license type from Per Proc to CAL ?

We had a production server installed with a Per Processor license by mistake
and need to change it to 'per seat' ie CAL. Is there a way to do this withou
t
reinstalling SQL on the server (as it is a production server now) ? The
'Choose Licensing Mode' in control panel has the 'per seat' option grayed ou
t
and only allows to change the number of processor licenses.
Thanks.Hi
"Pranil" wrote:

> We had a production server installed with a Per Processor license by mista
ke
> and need to change it to 'per seat' ie CAL. Is there a way to do this with
out
> reinstalling SQL on the server (as it is a production server now) ? The
> 'Choose Licensing Mode' in control panel has the 'per seat' option grayed
out
> and only allows to change the number of processor licenses.
> Thanks.
With a production server it is better to be safe as downtime could be
costly, but you could try http://tinyurl.com/25rvyo
John|||Awesome - thanks!
"John Bell" wrote:

> Hi
> "Pranil" wrote:
>
> With a production server it is better to be safe as downtime could be
> costly, but you could try http://tinyurl.com/25rvyo
> John

How to change license type from Per Proc to CAL ?

We had a production server installed with a Per Processor license by mistake
and need to change it to 'per seat' ie CAL. Is there a way to do this without
reinstalling SQL on the server (as it is a production server now) ? The
'Choose Licensing Mode' in control panel has the 'per seat' option grayed out
and only allows to change the number of processor licenses.
Thanks.
Hi
"Pranil" wrote:

> We had a production server installed with a Per Processor license by mistake
> and need to change it to 'per seat' ie CAL. Is there a way to do this without
> reinstalling SQL on the server (as it is a production server now) ? The
> 'Choose Licensing Mode' in control panel has the 'per seat' option grayed out
> and only allows to change the number of processor licenses.
> Thanks.
With a production server it is better to be safe as downtime could be
costly, but you could try http://tinyurl.com/25rvyo
John
|||Awesome - thanks!
"John Bell" wrote:

> Hi
> "Pranil" wrote:
>
> With a production server it is better to be safe as downtime could be
> costly, but you could try http://tinyurl.com/25rvyo
> John
sql

how to change default data directory for SQL 2005

Hi, I've installed SQL 2005 and failed to change the default data
location during installation. Now I want to change it. Can I do this
without having to uninstall and reinstall? And furthermore, is there a
system stored procedure I can use to move existing data and log files
(master, msdb, AdventureWorks, etc.)? I seem to remember doing just
this with SQL 2000 some time back.

Thanks,
EricYou can specify the default database file locations using SQL Server
Management Studio. Right-click the server in the object explorer and select
Properties-->Database Settings.

The SQL 2005 Books Online includes detailed steps on moving database files.
There is a different procedure for system vs. user databases.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Eric Bragas" <ericbragas@.yahoo.comwrote in message
news:1159469015.718736.156300@.d34g2000cwd.googlegr oups.com...

Quote:

Originally Posted by

Hi, I've installed SQL 2005 and failed to change the default data
location during installation. Now I want to change it. Can I do this
without having to uninstall and reinstall? And furthermore, is there a
system stored procedure I can use to move existing data and log files
(master, msdb, AdventureWorks, etc.)? I seem to remember doing just
this with SQL 2000 some time back.
>
Thanks,
Eric
>

|||Thanks, Dan. This answers my question completely.

-Eric

how to change default data directory for SQL 2005

Hi, I've installed SQL 2005 and failed to change the default data
location during installation. Now I want to change it. Can I do this
without having to uninstall and reinstall? And furthermore, is there a
system stored procedure I can use to move existing data and log files
(master, msdb, AdventureWorks, etc.)? I seem to remember doing just
this with SQL 2000 some time back.

Thanks,
EricYou can specify the default database file locations using SQL Server
Management Studio. Right-click the server in the object explorer and select
Properties-->Database Settings.

The SQL 2005 Books Online includes detailed steps on moving database files.
There is a different procedure for system vs. user databases.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Eric Bragas" <ericbragas@.yahoo.comwrote in message
news:1159469015.718736.156300@.d34g2000cwd.googlegr oups.com...

Quote:

Originally Posted by

Hi, I've installed SQL 2005 and failed to change the default data
location during installation. Now I want to change it. Can I do this
without having to uninstall and reinstall? And furthermore, is there a
system stored procedure I can use to move existing data and log files
(master, msdb, AdventureWorks, etc.)? I seem to remember doing just
this with SQL 2000 some time back.
>
Thanks,
Eric
>

|||Thanks, Dan. This answers my question completely.

-Eric

how to change collations to SQL_Latin1_General_CP1_CI_AS?

Hi,
I installed SQL Server 2000 SP3a on win2003 in English with the
collation Latin1_General_CI_AS.
Now I want to restore a DB with SQL_Latin1_General_CP1_CI_AS.
I am not really interested to reinstall SQL-server.
I tried the rebuildm.exe-tool but it couldn´t start because some
process was still using SQL-Server (I stopped everything I knew).
Is there a special query or a software-tool which can handle this
transformation?
thanks in advance,
RagnarHi,
> I installed SQL Server 2000 SP3a on win2003 in English with the
> collation Latin1_General_CI_AS.
> Now I want to restore a DB with SQL_Latin1_General_CP1_CI_AS.
ONLY RESTORE?
SQL Server 2000 supports multiple collations.
SEE Books Online
[SQL Server Architecture]
+ [Database Architecture]
+ [Logical Database Components]
+ [Collations]
+ [Mixed Collation Environments]
PARA. Collations in BACKUP and RESTORE
--
SHINICHI YONEDA MXL04371@.nifty.ne.jp
Microsoft Most Valuable Professional
MVP for SQL Server 2002-2003
"Ragnar Heil" <r@.gnar.de> wrote in message
news:8a70509.0309262355.5d06abc1@.posting.google.com...
> Hi,
> I installed SQL Server 2000 SP3a on win2003 in English with the
> collation Latin1_General_CI_AS.
> Now I want to restore a DB with SQL_Latin1_General_CP1_CI_AS.
> I am not really interested to reinstall SQL-server.
> I tried the rebuildm.exe-tool but it couldn´t start because some
> process was still using SQL-Server (I stopped everything I knew).
> Is there a special query or a software-tool which can handle this
> transformation?
> thanks in advance,
> Ragnar|||I thought that the collation of
SQL_Latin1_General_CP1_CI_AS and Latin1_General_CP1_CI_AS
are the same.
Am I right ?|||Hi,
> SQL_Latin1_General_CP1_CI_AS and Latin1_General_CP1_CI_AS
> are the same.
I feel so too.
But,
Latin1_General_CI_AS (Windows collation)
SQL_Latin1_General_CP1_CI_AS (SQL collation)
And Mixed Collation Environments CAUSE Collation conflict ERROR (449)
--
SELECT CategoryName FROM Northwind.dbo.Categories
WHERE
CASE WHEN 1=1
THEN CategoryName COLLATE Latin1_General_CI_AS
ELSE CategoryName COLLATE SQL_Latin1_General_CP1_CI_AS
END
LIKE 'C%' COLLATE Latin1_General_CI_AS
--
CAUSE Collation conflict ERROR.
--
SELECT CategoryName FROM Northwind.dbo.Categories
WHERE
CASE WHEN 1=1
THEN CategoryName COLLATE Latin1_General_CI_AS
ELSE CategoryName COLLATE Latin1_General_CI_AS
END
LIKE 'C%' COLLATE Latin1_General_CI_AS
--
RETURN some records.
--
SHINICHI YONEDA MXL04371@.nifty.ne.jp
Microsoft Most Valuable Professional
MVP for SQL Server 2002-2003
"Johnny" <jtao@.ssc.nsw.gov.au> wrote in message
news:132601c3864c$393336c0$a101280a@.phx.gbl...
> I thought that the collation of
> SQL_Latin1_General_CP1_CI_AS and Latin1_General_CP1_CI_AS
> are the same.
> Am I right ?
>|||> SQL_Latin1_General_CP1_CI_AS and Latin1_General_CP1_CI_AS
> are the same.
They are not quite the same. Latin1_General_CI_AS uses Unicode sorting
rules for both Unicode and non-Unicode data. To see one difference (not
the only one), try the following:
IF 'a-c' COLLATE Latin1_General_CI_AS > 'ab' COLLATE
Latin1_General_CI_AS
PRINT 'Latin1_General_CI_AS: a-c > ab'
ELSE
PRINT 'Latin1_General_CI_AS: a-c < ab'
IF 'a-c' COLLATE SQL_Latin1_General_CP1_CI_AS > 'ab' COLLATE
SQL_Latin1_General_CP1_CI_AS
PRINT 'SQL_Latin1_General_CP1_CI_AS: a-c > ab'
ELSE
PRINT 'SQL_Latin1_General_CP1_CI_AS: a-c < ab'
> I tried the rebuildm.exe-tool but it couldn´t start because some
> process was still using SQL-Server (I stopped everything I knew).
To use rebuildm.exe, make sure that the SQL Server service is fully stopped
(e.g. go to Computer Managment --> Services and stop anything named
"MSSQLServer" or "MSSQL$...").
Bart
--
Please reply to the newsgroup only - thanks.
This posting is provided "AS IS" with no warranties, and confers no rights.
From: "Shinichi Yoneda" <mxl04371@.nifty.ne.jp>
References: <8a70509.0309262355.5d06abc1@.posting.google.com>
<OOX7gGVhDHA.1200@.TK2MSFTNGP12.phx.gbl>
<132601c3864c$393336c0$a101280a@.phx.gbl>
Subject: Re: how to change collations to SQL_Latin1_General_CP1_CI_AS?
Date: Mon, 29 Sep 2003 21:45:35 +0900
Lines: 48
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <ePiiaeohDHA.4024@.TK2MSFTNGP11.phx.gbl>
Newsgroups: microsoft.public.sqlserver.server
NNTP-Posting-Host: ntehme007118.ehme.nt.adsl.ppp.infoweb.ne.jp
218.229.98.118
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:308787
X-Tomcat-NG: microsoft.public.sqlserver.server
Hi,
> SQL_Latin1_General_CP1_CI_AS and Latin1_General_CP1_CI_AS
> are the same.
I feel so too.
But,
Latin1_General_CI_AS (Windows collation)
SQL_Latin1_General_CP1_CI_AS (SQL collation)
And Mixed Collation Environments CAUSE Collation conflict ERROR (449)
--
SELECT CategoryName FROM Northwind.dbo.Categories
WHERE
CASE WHEN 1=1
THEN CategoryName COLLATE Latin1_General_CI_AS
ELSE CategoryName COLLATE SQL_Latin1_General_CP1_CI_AS
END
LIKE 'C%' COLLATE Latin1_General_CI_AS
--
CAUSE Collation conflict ERROR.
--
SELECT CategoryName FROM Northwind.dbo.Categories
WHERE
CASE WHEN 1=1
THEN CategoryName COLLATE Latin1_General_CI_AS
ELSE CategoryName COLLATE Latin1_General_CI_AS
END
LIKE 'C%' COLLATE Latin1_General_CI_AS
--
RETURN some records.
--
SHINICHI YONEDA MXL04371@.nifty.ne.jp
Microsoft Most Valuable Professional
MVP for SQL Server 2002-2003
"Johnny" <jtao@.ssc.nsw.gov.au> wrote in message
news:132601c3864c$393336c0$a101280a@.phx.gbl...
> I thought that the collation of
> SQL_Latin1_General_CP1_CI_AS and Latin1_General_CP1_CI_AS
> are the same.
> Am I right ?
>
From: "Shinichi Yoneda" <mxl04371@.nifty.ne.jp>
Subject: Re: how to change collations to SQL_Latin1_General_CP1_CI_AS?
Date: Sun, 28 Sep 2003 08:46:34 +0900
Newsgroups: microsoft.public.sqlserver.server
Hi,
> I installed SQL Server 2000 SP3a on win2003 in English with the
> collation Latin1_General_CI_AS.
> Now I want to restore a DB with SQL_Latin1_General_CP1_CI_AS.
ONLY RESTORE?
SQL Server 2000 supports multiple collations.
SEE Books Online
[SQL Server Architecture]
+ [Database Architecture]
+ [Logical Database Components]
+ [Collations]
+ [Mixed Collation Environments]
PARA. Collations in BACKUP and RESTORE
--
SHINICHI YONEDA MXL04371@.nifty.ne.jp
Microsoft Most Valuable Professional
MVP for SQL Server 2002-2003
"Ragnar Heil" <r@.gnar.de> wrote in message
news:8a70509.0309262355.5d06abc1@.posting.google.com...
> Hi,
> I installed SQL Server 2000 SP3a on win2003 in English with the
> collation Latin1_General_CI_AS.
> Now I want to restore a DB with SQL_Latin1_General_CP1_CI_AS.
> I am not really interested to reinstall SQL-server.
> I tried the rebuildm.exe-tool but it couldn´t start because some
> process was still using SQL-Server (I stopped everything I knew).
> Is there a special query or a software-tool which can handle this
> transformation?
> thanks in advance,
> Ragnar|||"Shinichi Yoneda" <mxl04371@.nifty.ne.jp> wrote
> > I installed SQL Server 2000 SP3a on win2003 in English with the
> > collation Latin1_General_CI_AS.
> > Now I want to restore a DB with SQL_Latin1_General_CP1_CI_AS.
> ONLY RESTORE?
> SQL Server 2000 supports multiple collations.
> SEE Books Online
> [SQL Server Architecture]
> + [Database Architecture]
> + [Logical Database Components]
> + [Collations]
> + [Mixed Collation Environments]
> PARA. Collations in BACKUP and RESTORE
Hello,
I read this chapter and it seems that I just have to create a new DB,
choose the right collation and restore the DB. The message is that
multiple collations are supported and a feature of SQL 2000.
But the fact is that I can't choose "SQL_Latin1_General_CP1_CI_AS"
while creating a new DB.
So what I did is I reinstalled SQL Server, changed regional-settings
to English(US), English (UK) for the local user.
Then I got the right collation.
cheers
Ragnar|||Why you can't choose "SQL_Latin1_General_CP1_CI_AS" while
creating a new DB.
I got a SQL server which has server collation
Latin1_General_CI_AS. It is the same as yours. I can
create a brand new db with collation
SQL_Latin1_General_CP1_CI_AS or Latin1_General_CI_AS.|||On Tue, 30 Sep 2003 21:51:20 -0700, "Johnny" <jtao@.ssc.nsw.gov.au>
wrote:
>Why you can't choose "SQL_Latin1_General_CP1_CI_AS" while
>creating a new DB.
>I got a SQL server which has server collation
>Latin1_General_CI_AS. It is the same as yours. I can
>create a brand new db with collation
>SQL_Latin1_General_CP1_CI_AS or Latin1_General_CI_AS.
Yes, but then you will have problems with temp tables, as they will be
created with the same collation as the master database by default.
You can get around this issue, by specifying
"collation database_default" for each character-type column when you
create your temp tables. Of course, that means you need to create them
up-front, and can't use Select ... Into #xxx From ... anymore.
cheers,
Ross.
--
Ross McKay, WebAware Pty Ltd
"Words can only hurt if you try to read them. Don't play their game" - Zoolander|||Hi,
(a)TRY
SELECT * FROM ::fn_helpcollations()
YOU CAN SEE list of all the collations supported by YOUR SQL Server 2000.
EX.
Latin1_General_CI_AS,Latin1-General, case-insensitive, accent-sensitive,
kanatype-insensitive, width-insensitive
SQL_Latin1_General_CP1_CI_AS,Latin1-General, case-insensitive,
accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data,
SQL Server Sort Order 52 on Code Page 1252 for non-Unicode Data
> But the fact is that I can't choose "SQL_Latin1_General_CP1_CI_AS"
> while creating a new DB.
(b)creating a new DB. BUT WITHOUT COLLATION
RESTORE DATABASE WITH REPLACE
the existing database is completely replaced with the contents of the
database on the backup file.
(AFTER RESTORE, COLLATION SQL_Latin1_General_CP1_CI_AS)
(c)FOR Rebuildm.exe YOU MUST COPY FILES FROM CD TO HDD. REMOVE Read-only
attribute.
http://support.microsoft.com/default.aspx?scid=kb;en-us;273572
BUG: Rebuildm.exe Utility Stops Responding When Source Directory is on a CD
--
SHINICHI YONEDA MXL04371@.nifty.ne.jp
Microsoft Most Valuable Professional
MVP for SQL Server 2002-2003
"Ragnar Heil" <r@.gnar.de> wrote in message
news:8a70509.0309300437.7b617e5b@.posting.google.com...
> "Shinichi Yoneda" <mxl04371@.nifty.ne.jp> wrote
> > > I installed SQL Server 2000 SP3a on win2003 in English with the
> > > collation Latin1_General_CI_AS.
> > > Now I want to restore a DB with SQL_Latin1_General_CP1_CI_AS.
> > ONLY RESTORE?
> > SQL Server 2000 supports multiple collations.
> > SEE Books Online
> > [SQL Server Architecture]
> > + [Database Architecture]
> > + [Logical Database Components]
> > + [Collations]
> > + [Mixed Collation Environments]
> > PARA. Collations in BACKUP and RESTORE
> Hello,
> I read this chapter and it seems that I just have to create a new DB,
> choose the right collation and restore the DB. The message is that
> multiple collations are supported and a feature of SQL 2000.
> But the fact is that I can't choose "SQL_Latin1_General_CP1_CI_AS"
> while creating a new DB.
> So what I did is I reinstalled SQL Server, changed regional-settings
> to English(US), English (UK) for the local user.
> Then I got the right collation.
>
> cheers
> Ragnar

How to change collation settings after install

I need to change the collation setting on a server which has already been
installed and setup. How do I do this?
Thanks.
moondaddy@.newsgroup.nospamIt depends on to what extent you want to change collation. The collation for system databases you
change using rebuildm.exe (2000) or setup (2005). See books online for details. This will rebuild
the system databases, so you need to recreate everything you need in the system databases.
A user database is a different thing...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"moondaddy" <moondaddy@.newsgroup.nospam> wrote in message
news:eTbPg7gAIHA.4232@.TK2MSFTNGP04.phx.gbl...
>I need to change the collation setting on a server which has already been installed and setup. How
>do I do this?
> Thanks.
>
> moondaddy@.newsgroup.nospam
>|||Take a look at this tip:
http://www.sqlcommunity.com/Default.aspx?grm2id=25&tabid=77
Hope this helps.
Saleem
WWW.SQLCOMMUNITY.COM
SQL Server Tips, SQL Server Scripts, SQL Server Forums, SQL Server Blogs,
SQL Server Radio, SQL Server Events..
"Tibor Karaszi" wrote:
> It depends on to what extent you want to change collation. The collation for system databases you
> change using rebuildm.exe (2000) or setup (2005). See books online for details. This will rebuild
> the system databases, so you need to recreate everything you need in the system databases.
> A user database is a different thing...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "moondaddy" <moondaddy@.newsgroup.nospam> wrote in message
> news:eTbPg7gAIHA.4232@.TK2MSFTNGP04.phx.gbl...
> >I need to change the collation setting on a server which has already been installed and setup. How
> >do I do this?
> >
> > Thanks.
> >
> >
> > moondaddy@.newsgroup.nospam
> >
>|||Hi,
I agree with Tibor. Just add some helpful links here for your reference.
For SQL 2000, please refer to:
How to rebuild the master database (Rebuild Master utility)
http://msdn2.microsoft.com/en-us/library/aa197950(sql.80).aspx
For SQL 2005, you may refer to:
Setting and Changing the Server Collation
http://msdn2.microsoft.com/en-us/library/ms179254.aspx
How to: Install SQL Server 2005 from the Command Prompt
http://msdn2.microsoft.com/en-us/library/ms144259.aspx
Additionally if you would like to change your user database collation, you
can use ALTER DATABASE statement which is applicable for both SQL 2000 and
2005:
Setting and Changing the Database Collation
http://msdn2.microsoft.com/en-us/library/ms175835.aspx
ALTER DATABASE (Transact-SQL)
http://msdn2.microsoft.com/en-us/library/ms174269.aspx
Please feel free to let us know if you have any questions or concerns.
Best regards,
Charles Wang
Microsoft Online Community Support
======================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================

How to change "sa" password after installation?

I just installed MS SQL SERVER2000, but seems the password I was setting didn't look good. So I want to change it, but how? Thanks!run stored procedure using account with sysadmin role priveleges

sp_password @.new = 'newprd' , @.loginame = 'sa'

ask if you have any questions|||run stored procedure using account with sysadmin role priveleges

sp_password @.new = 'newprd' , @.loginame = 'sa'

ask if you have any questions

I've figured it out, thanks!