thanks i never knew that, iam writing triggers for the first time i guess

i have deleted for that table, i have wrote similar trigger for another

table

iam pasting code

USE [joblist]

GO

/****** Object: Trigger [toempemails] Script Date: 06/11/2008 14:19:22 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

create TRIGGER [toempemails]

on [dbo].[empemails] INSTEAD OF UPDATE

as

IF EXISTS (SELECT * FROM deleted WHERE companyname like '%.js')

begin

print 'trying to insert virus'

end

--select * from empemails