How to change collation settings of a database

Hi,
what would be the best way to change the collation settings of a database? I
need to change the collation from SQL_Latin1_General_CP1_CI_AS to
Latin1_General_CI_AS.
Thank you a lot in advance!
Danielhttp://msdn.microsoft.com/library/d...br />
819v.asp
ML|||Hi,
have a look at the alter database TSQL in BOL. Thanks
--
--
Thanks,
Ibrahim
If you find this post useful, please click 'yes'
"Daniel Walzenbach" wrote:

> Hi,
> what would be the best way to change the collation settings of a database?
I
> need to change the collation from SQL_Latin1_General_CP1_CI_AS to
> Latin1_General_CI_AS.
> Thank you a lot in advance!
> Daniel|||Thank you ML!
Regards
Daniel
"ML" wrote:

> http://msdn.microsoft.com/library/d... />
a_819v.asp
>
> ML|||Just be make sure you perused the previously posted Books Online topic,
please note the following excerpt:
<Excerpt>
Altering the default collation of a database does not change the collations
of the columns in any existing user-defined tables. These can be changed
with ALTER TABLE. The COLLATE CLAUSE on an ALTER DATABASE statement changes:
</Excerpt>
Hope this helps.
Dan Guzman
SQL Server MVP
"Daniel Walzenbach" <daniel.walzenbach@.newsgroup.nospam> wrote in message
news:E4DEF1D9-83C8-4762-A99E-6B67F94C6261@.microsoft.com...
> Hi,
> what would be the best way to change the collation settings of a database?
> I
> need to change the collation from SQL_Latin1_General_CP1_CI_AS to
> Latin1_General_CI_AS.
> Thank you a lot in advance!
> Daniel|||Hi Dan,
the excerpt you posted is exactly the problem I have. Do you see any
solution to solve this?
Thank you!
Daniel
"Dan Guzman" wrote:

> Just be make sure you perused the previously posted Books Online topic,
> please note the following excerpt:
> <Excerpt>
> Altering the default collation of a database does not change the collation
s
> of the columns in any existing user-defined tables. These can be changed
> with ALTER TABLE. The COLLATE CLAUSE on an ALTER DATABASE statement change
s:
> </Excerpt>
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Daniel Walzenbach" <daniel.walzenbach@.newsgroup.nospam> wrote in message
> news:E4DEF1D9-83C8-4762-A99E-6B67F94C6261@.microsoft.com...
>
>|||Unfortunately, there is no easy way to change the collation of all existing
columns to the new collation. You'll need to recreate the tables. See
http://support.microsoft.com/defaul...b;en-us;325335.
Hope this helps.
Dan Guzman
SQL Server MVP
"Daniel Walzenbach" <daniel.walzenbach@.newsgroup.nospam> wrote in message
news:F704636E-CA46-42DD-AD1B-07D15243351F@.microsoft.com...
> Hi Dan,
> the excerpt you posted is exactly the problem I have. Do you see any
> solution to solve this?
> Thank you!
> Daniel
> "Dan Guzman" wrote:
>|||Dan,
I feared so ;-)
Thanks for you reply! Regards
Daniel
"Dan Guzman" wrote:

> Unfortunately, there is no easy way to change the collation of all existin
g
> columns to the new collation. You'll need to recreate the tables. See
> http://support.microsoft.com/defaul...b;en-us;325335.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Daniel Walzenbach" <daniel.walzenbach@.newsgroup.nospam> wrote in message
> news:F704636E-CA46-42DD-AD1B-07D15243351F@.microsoft.com...
>
>