var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Date Value Question trigger
Currently have a table (SiteValues) that when updated inserts the a date/time into column called (ClDateTimeA).
I have another table (CurrDate) with a current date column known as (CurrDate)
I want to create a trigger that delete's the row in the table SiteValues whenever (ClDateTimeA) the row has gone over its specified date by 2 weeks.
How may i accomplish this.
Sounds like you want a scheduled job rather than a trigger.
Look at management/sql server agent/jobs in enterprise manager.