There may be many cases where a tables needs to be made as read-only in order to maintain the existing data. This can be achieved using many ways and out of which the common methods are
- Deny Permission
- Put the table on read only file group
- Create trigger instead of insert, update, delete
- Make the database read-only
- Create a Column Store Index