SQL Trigger Help Needed

[sila]

Hi

I have a table with a field in it caled CountToClose, this is set to a date 09/05/2005 14:32:49 and after 4 days have elapsed another field in the database called CloseDown needs to be set to 1. I assume I need a trigger for this to happen but have not ever done this before and dont know how to begin?

Thanks
Sila.

 

[jgoodman00]

A trigger probably wont help you, because it will only execute if an operation on the table is executed.

You are probably better off creating an sp which updates the closedown column, & then executing this as a SQL Agent job every night.

James Goodman MCSE, MCDBA

http://www.j.goodman.dsl.pipex.com