Database collation

how to change database collation?On Mon, 27 Feb 2006 20:01:44 +0100, Tale wrote:
>how to change database collation?
>
Hi Tale,
ALTER DATABASE databasename
COLLATE collationname
--
Hugo Kornelis, SQL Server MVP|||... and if the existing object's collation also need to be changed, so ALTER TABLE ... ALTER COLUMN
for each string column in each table.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Hugo Kornelis" <hugo@.perFact.REMOVETHIS.info.INVALID> wrote in message
news:drpe02pkevmct79b5nl8tfct2mm3c12io4@.4ax.com...
> On Mon, 27 Feb 2006 20:01:44 +0100, Tale wrote:
>>how to change database collation?
> Hi Tale,
> ALTER DATABASE databasename
> COLLATE collationname
> --
> Hugo Kornelis, SQL Server MVP|||Thanks
to you have any script for this operations - change collations for every
table / column
all in one
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%238MFa0vPGHA.2108@.TK2MSFTNGP10.phx.gbl...
> ... and if the existing object's collation also need to be changed, so
> ALTER TABLE ... ALTER COLUMN for each string column in each table.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Hugo Kornelis" <hugo@.perFact.REMOVETHIS.info.INVALID> wrote in message
> news:drpe02pkevmct79b5nl8tfct2mm3c12io4@.4ax.com...
>> On Mon, 27 Feb 2006 20:01:44 +0100, Tale wrote:
>>how to change database collation?
>>
>> Hi Tale,
>> ALTER DATABASE databasename
>> COLLATE collationname
>> --
>> Hugo Kornelis, SQL Server MVP
>|||I haven't seen such script, but I haven't been looking for one either. Perhaps you can find if you
Google?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Tale" <tales@.eunet.yu> wrote in message news:duueuf$gst$1@.news.eunet.yu...
> Thanks
> to you have any script for this operations - change collations for every
> table / column
> all in one
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:%238MFa0vPGHA.2108@.TK2MSFTNGP10.phx.gbl...
>> ... and if the existing object's collation also need to be changed, so ALTER TABLE ... ALTER
>> COLUMN for each string column in each table.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Hugo Kornelis" <hugo@.perFact.REMOVETHIS.info.INVALID> wrote in message
>> news:drpe02pkevmct79b5nl8tfct2mm3c12io4@.4ax.com...
>> On Mon, 27 Feb 2006 20:01:44 +0100, Tale wrote:
>>how to change database collation?
>>
>> Hi Tale,
>> ALTER DATABASE databasename
>> COLLATE collationname
>> --
>> Hugo Kornelis, SQL Server MVP
>