Thank you!

Craig,

Thank you,

i think i got it 🙂

/****** Object: Trigger [dbo].[trg_SourceHistory] Script Date: 02/22/2011 14:54:56 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER TRIGGER [dbo].[trg_SourceHistory]

ON [dbo].[tblSource]

for UPDATE

AS

begin try

INSERT...

do i then have to list ALL values, or can i just list the ones i want to keep track of? how would it know where to put them?

when i change it to INSERTED, it still does not go though... is there a way to debug it somehow to see where the error is? or to maybe get...

i'm using enterprise manager import wizard to import, here is an example of what's going on.

my table, for example, has the following fields:

id (self incrementing key field)

name

address

phone

date_modified (has a default...

i'm using the enterprise manager import wizard