How to use/create triggers in sql server 2000

i have used triggers using the oracle as database,
but i'm not able create triggers in sql server, plz help
how to create triggers.Check out books online under CREATE TRIGGER, there are two different types,
INSTEAD OF (executes before the transaction) and AFTER (after the action and
in the transaction).
The trigger fires once for the statement and not per row, so if you where
inserting 5 rows the trigger would execute once and not 5 times, the rows
affected can be found in the 'inserted', 'deleted' tables.
Tony.
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials
"shiva" <bany.shanker@.gmail.com> wrote in message
news:1133161769.576911.208680@.f14g2000cwb.googlegroups.com...
>i have used triggers using the oracle as database,
> but i'm not able create triggers in sql server, plz help
> how to create triggers.
>|||Hi
You can either do this through Enterprise manager by right clicking the
table in the tree view and choosing all tasks/manage triggers or a more
versatile option is to use Query Analyser and create a script to create the
trigger. See Books online for the CREATE TRIGGER statement or at
http://msdn.microsoft.com/library/d... />
2_7eeq.asp
John
"shiva" wrote:

> i have used triggers using the oracle as database,
> but i'm not able create triggers in sql server, plz help
> how to create triggers.
>|||Look in the BOl for that, there are some good exmaples for that.
http://www.aspfaq.com/show.asp?id=2229
HTH, Jens Suessmeyer.