PABLO_ALCH (pablo@lavietimetech.com) writes:
> I've got a similar problem: whenever I try to alter the collation of a
> DATABASE, using ALTER DATABASE COLLATE <collation_name, unknown until
> run time>
> I get Msg 5075, because there is a schema-bound view in the database.
>
> Do you know of any way around this, short of dropping and re-creating
> the view?

I will have to ask: what is the point of changing the database collation
until runtime?

The only thing you change is the default collation for new columns and
the collation for variables. The collation of existing columns is
unchanged.

Maybe you are aware of this, and understand how to handle this, but I
can't see any point with this. So maybe your problem is wider than just
the schemabound view.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp