Brent Ozar says:
Stop People From Changing Tables with This One Trick
Brace yourselves. Our Black Friday sale is coming.
Developers hate his bad idea jeans:
CREATE VIEW dbo.StopThemDead WITH SCHEMABINDING
SELECT COUNT(*) FROM dbo.Table1
SELECT COUNT(*) FROM dbo.Table2
Presto, the schemabinding option means no one can change the underlying tables. (At least, until they figure out about your view.)
Obligatory disclaimer: seriously, this is a really bad idea. But it’s hilarious.