Bill Fellows has a script to test each view to see if it is broken:
Shh, shhhhhh, we’re being very very quiet, we’re hunting broken views. Recently, we were asked to migrate some code changes and after doing so, the requesting team told us we had broken all of their views, but they couldn’t tell us what was broken, just that everything was. After a quick rollback to snapshot, thank you Red Gate SQL Compare, I thought it’d be enlightening to see whether anything was broken before our code had been deployed.
You’ll never guess what we discovered.
Read on to see what they discovered (spoilers: broken views) and how Bill fixed the problem.