I have created a trigger for insert and whenevr i insert a record it must notify or insert the values in my log table,i want to know how we know trigger is fired?? please help me with this?
my trigger for insert
create trigger insert2
declare @sno int,@result varchar(50)
select @sno=sno,@result=@result from insert1
insert into triglog values (@sno,@result)
but i am getting this error An explicit value for the identity column in table 'triglog' can only be specified when a column list is used and IDENTITY_INSERT is ON.help me with this? thanks.
View Complete Post