DOCI to Binary

Is possible to change an existing database from DOCI to Binary
Thanks
DeaDean,
Are you referring to changing collation of the database here? If you change
the collation of a database using ALTER DATABASE only new columns will use
the new collation. Existing columns will use their old collation. To change
existing columns from one collation to a new one, you must use ALTER
TABLE...ALTER COLUMN for all tables. This is a lot of work and you may run
into issues with various constraints that you may have defined.
You may find it easier to create a new database with the new collation and
then DTS the data over from the old database. You can then drop the old
database, and rename your new database to the old name. I hope I read your
vague question correctly, and I'm not barking up the wrong tree... :-)
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"Dean" <anonymous@.discussions.microsoft.com> wrote in message
news:EBE6DFAC-0886-4646-A296-C83762CEB875@.microsoft.com...
> Is possible to change an existing database from DOCI to Binary?
> Thanks,
> Dean
>