Tuesday, March 27, 2012

Changing the server collations SQL 2005 Express

How do you change the collation on the master and temp DB
Thanks
AnthonyHello,
As far as I know you cant change the collation of system databases directly.
To do this you may need to rebuild the master database.
http://support.microsoft.com/?kbid=325335#7
Thanks
Hari
"Anthony" <Anthony@.discussions.microsoft.com> wrote in message
news:72FBD92B-A5E3-488D-8E60-56C6A36B48AA@.microsoft.com...
> How do you change the collation on the master and temp DB
> Thanks
> Anthony|||Thanks for the reply.
but this is for sql 2005 not 2000. It is not done in the same way.
"Hari Prasad" wrote:

> Hello,
> As far as I know you cant change the collation of system databases directl
y.
> To do this you may need to rebuild the master database.
> http://support.microsoft.com/?kbid=325335#7
> Thanks
> Hari
>
> "Anthony" <Anthony@.discussions.microsoft.com> wrote in message
> news:72FBD92B-A5E3-488D-8E60-56C6A36B48AA@.microsoft.com...
>
>

No comments:

Post a Comment