Alter Database Collation ( If possible )

Dear Experts ,
Can i change my existing database collation with new one ,if it is possible
than how i will be done.
Thank's for any suggesion .
Faheem Latif
NETWORK SOLUTIONHello Faheem,
You can change the default database collation by writing something like
this:
ALTER DATABSE [testing] COLLATE French_CI_AS
But - this will only change the collation for any new tables. Already
created tables will keep their collation, and you have to change them also,
if that's what you're looking for. Look in BOL for the ALTER TABLE syntax to
change the collation of a table.
HTH,
Andrs Taylor
"Faheem" <anonymous@.discussions.microsoft.com> wrote in message
news:EFF8D2E4-951F-470B-B75D-DFCCE4F1C237@.microsoft.com...
> Dear Experts ,
> Can i change my existing database collation with new one ,if it is
possible than how i will be done.
> Thank's for any suggesion .
> Faheem Latif
> NETWORK SOLUTION