Hi,

I hope some kind soul can help me. I have a table with a date column holding a future date. I would like to have a trigger fire off if today's date has passed by this date and alter a text value of another column from a default of 'inside' to 'outside'. Does anyone have any suggestions on how to create this trigger?

Sorry for the newbie question!! :)

Thanks

Mosser212

You'd better served with a programmed job at the 00:01 everyday , to check on that table if there are values wich require attention. A simple T-SQL would do then :)

---

Hey , sysadm , leave the users alone
They are nothing more
than another brick in the firewall

Thanks for that, I'll do that!! :)

Mosser212