Agreed...for SQL 7 and 2000, the second way is better and faster. What about 6.5, any idea?? Haaha...

Sorry.... your insert is not enough values

the getdate do not return any value ...are you using 6.5? the solution applied to SQL7 or 2000

try add @ed datetime

Declare @RecordNo Int, @UserName Varchar...

SIMPLE Trigger to DELETE and add the deleted to the different tables two or more

Create trigger trgDeltblA

On tblA

For Delete

As 

Declare @UserName Varchar(500), @Title   Varchar(50),

 @ID int

Select @UserName =User,@ID = BiodataID From Deleted

Begin

insert into...

Thanks to all of you guys... your info(s) make me happy. Now i get the idea to move from 6.5 to 7 or 2000.

But still sad bcoz i have to...