SQLTeam.com | Weblogs | Forums

Auto Update of the Table in sql Server 2008

I want update or change the status of a column in a table after 24 hours entering in the database.

How i can achieve this one with code.

I am using Sql server 2008


Write a simple SQL Server Agent job to do the update.

Having such temporal dependencies in tables that require something external to be executed is a REALLY bad idea on several levels. This really should be done in the code that accesses the table.