Thanku sir :-)
----- Original Message -----
From: Brian Freeman <freeman@C...>
To: sql language <sql_language@p...>
Sent: Thursday, October 17, 2002 5:35 PM
Subject: [sql_language] RE: Nested Insert Trigger


> In order for a trigger to fire itself you need to set "recursive triggers"
> on.  In SQL Server this is done by:
> ALTER DATABASE myDatabase
>    SET RECURSIVE_TRIGGERS ON (or off)
>
> Otherwise the insert trigger only fires once.  Also in SQL Server it will
> only fire 32 times and then will error out (because nesting can only occur
a
> maximum of 32 levels deep).
>
>
>
> Brian Freeman
>  (xxx) xxx-xxxx  ext. 415
> Carnegie Technologies/Bluewave Computing
> www.carnegie.com and www.bluewave-computing.com
>
> -----Original Message-----
> From: Abhijeet Raje [mailto:abhijeet2804@h...]
> Sent: Thursday, October 17, 2002 6:32 AM
> To: sql language
> Subject: [sql_language] Nested Insert Trigger
>
>
> Hi! ALL
>
> I have a table call test
>
> ID int no 4 (Identity)
> Name char no 10
>
> I wrote a trigger
>
> CREATE TRIGGER keepInserting ON [dbo].[test]
> FOR INSERT
> AS
> Insert into test values ('C')
>
> ######
> When I run a SQL  insert into test values ('jj') Only a single  record
with
> Name 
> 'C' get inserted..
>
> Why the Insert SQL in side Trigger unable to  fires Trigger again. I think
> that I sould have
> my table filled with all 'C's.
>
> Please help
>
>
>
>
>
>
>
>
>
>