How to set trigger to perform an operation on table.

See more:

ASP.NET

validation

trigger

I have a table in ms sql server. I want to set trigger that whenever today is finishdate the column IsActive is set to false. or MaxNotification & MaxArticles & MaxVideos & MaxEvent = 0 Set IsActive = false.
How would i achieve this...please help...

Create Table TblSubscription
(
SubscriptionId int identity(1,1) Primary key,
UserId INT NOT NULL Foreign key References TblUser(UserId),
PackageId INT NOT NULL Foreign key References TblPackages(PackageID),
ConstID INT NOT NULL Foreign key References TblConstituency (ConstID),
StartDate datetime,
FinishDate datetime,
MaxNotification int,
MaxArticles int,
MaxVideos int,
MaxEvent int,
MaxAllias int,
Cost float,
IsActive bit,
IsPaid bit
);