Script to Create Trigger for each table to make read-only and block any updates or modification apart from Replication.
–Create Triggers for protection SET NOCOUNT ON ;With AllTables as (SELECT NAME, SCHEMA_NAME(t.[schema_id]) AS SchemaName FROM sys.tables AS t WHERE t.is_ms_shipped = 0 ) SELECT ‘CREATE TRIGGER tr_’ + SchemaName + ‘_’ + NAME + ‘ ON [‘ + SchemaName
SQL-BOX.COM 