Home Forums SQL Server 2008 SQL Server 2008 High Availability compressing read only file groups RE: compressing read only file groups
Steve Jones - SSC Editor
SSC Guru
Points: 734552
More actions
February 27, 2014 at 4:15 pm
#1692919
You don't write a trigger based on a range or partition. You write it based on the table.
If the read only groups are 3 months old, then your trigger just has something like
if datePKcolumn < dateadd( mm, -3, getdate()) then
rollback