About trigger

is it possible to run a trigger forever... whose work is to archive data from a table. or how can i do the operation to archive automatically ?

Regards,

Kamrul Hassan

Well... triggers cannot be used for schedule tasking, there are certain some ways to do this.
1st) if you are running on dedicated server then you can use windows service to update records periodically
2nd) Use Sql Server jobs. to know more about sql server jobs http://msdn2.microsoft.com/en-us/library/ms187880.aspx

cheers..