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