Hi ,
Check This
By the way only trigger have the ability to get to
deleted and inserted
there is nothing called updated
CREATE TRIGGER UserTrigger13
ON Users
After update
AS
BEGIN
DECLARE @Username nvarchar(50)
DECLARE @Num int
SET @Username = (SELECT Username FROM inserted)
SET @Num = 0
UPDATE Users SET UserLoginAttempts = @Num WHERE UserBlocked = 0 AND Username = @Username
BEGIN
SET NOCOUNT ON;
END
END
for reference
http://msdn.microsoft.com/en-us/library/aa258254%28v=sql.80%29.aspx[
^]
Best Regards
M.Mitwalli