title: How to force sql server to ignore insert on computed column instead of throwing error?
body: <p>I have a table to which I would like to add computed column (with values different for each user - needed for permissions).
  <br>Problem is that this table is part of Microsoft Dynamics NAV which don't know anything about computed columns.
  <br>I've managed how to cheat NAV so that I change the column type after NAV creates it and I can read the data.<br>
  <br>
  Now I'm stuck with inserts.<br>
  NAV don't use nullable columns so it always tries to insert default value and SQL Server fails with error on computed column.<br>
  I've tried to write INSTEAD OF INSERT trigger but seems that SQL Server is doing the check before it runs the trigger and still fails with error.<br></p>
  
  <p>Is there any way to force SQL Server to ignore inserted value on computed column?</p>