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.
======================================================