Force DATABASE ALTER ignoring errors

As the name says, force the alter database to alter its collation ignoring the error message that I get from functio开发者_如何学Cns or calculated columns that compare data.

Is there a way to do so?

Like IGNORE_ERRORS or something like that? Thanks a lot!

No, because your data and database will be broken if you could ignore errors. Which is bad thing.

See this recent question about changing collation for inspiration, hopefully

Maybe you can use transactions.

begin transaction;
alter table ...
... repair calculated colums ...
commit;

Normally it should not be possible that you can make changes to your database which leave it in an inconsistent state. See ACID