collation problem

When I create a database it takes the default collation of my server. Okay
so far.
But if I later try to change the default collation of the database, this
does not work.
I use:
ALTER DATABASE [test2]
COLLATE SQL_Latin1_General_CP1_CI_AS
GO
This command runs succesful (says the Query Analyzer), but when I look at
the properties of the database in the Enterprise Manager the collation is
empty, and if I generate a CREATE TABLE command with the Query Analyzer then
the server collation is used.
So it looks if nothing happened.
What's wrong?
Jan van Veldhuizen
What does this have to do with DTS ?
That said this works for me
CREATE DATABASE A
GO
EXEC sp_helpdb 'A'
--Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER,
Recovery=FULL, Version=539, Collation=Latin1_General_CI_AS, SQLSortOrder=0,
IsTornPageDetectionEnabled, IsAutoCreateStatistics, IsAutoUpdateStatistics
ALTER DATABASE [A]
COLLATE SQL_Latin1_General_CP1_CS_AS
EXEC sp_helpdb 'A'
--Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER,
Recovery=FULL, Version=539, Collation=SQL_Latin1_General_CP1_CS_AS,
SQLSortOrder=51, IsTornPageDetectionEnabled, IsAutoCreateStatistics,
IsAutoUpdateStatistics
--
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know
"Jan van Veldhuizen" <jan@.van-veldhuizen.nl> wrote in message
news:u3Q3a$UhEHA.2416@.TK2MSFTNGP10.phx.gbl...
> When I create a database it takes the default collation of my server. Okay
> so far.
> But if I later try to change the default collation of the database, this
> does not work.
> I use:
> ALTER DATABASE [test2]
> COLLATE SQL_Latin1_General_CP1_CI_AS
> GO
> This command runs succesful (says the Query Analyzer), but when I look at
> the properties of the database in the Enterprise Manager the collation is
> empty, and if I generate a CREATE TABLE command with the Query Analyzer
then
> the server collation is used.
> So it looks if nothing happened.
> What's wrong?
> Jan van Veldhuizen
>
>