how to create trigger in sqlserver 2000?

[sujata routray]

__________________________________________________________
Enjoy this Diwali with Y! India Click here http://in.promos.yahoo.com/fabmall/index.html

[BabuLives]

hai...

USE pubs
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'mytrigger' AND type = 'TR')
DROP TRIGGER mytrigger
GO
CREATE TRIGGER mytrigger
ON TableName FOR INSERT[UPDATE/DELETE]
AS
Update tablename set col='Inserted'
GO

Regards,
Satheesh