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