Sorry for posting on three year old thread.

Just curious to know if there's any solution for a similar situation. I have an archive database in which the stored procedures should be executed but shouldn't insert\update\delete any records. It may give error if it gets to run the DML statements.

many thanks...