Posted by danceli on 01/31/07 18:20

1.
> You are missing data but where? You appear to extract data withBCP, do
> you load it anywhere else?

On table Eventlog, there are missing data.


2.
> > create trigger trgEventUpdate on EventLog For Insert,Update as
> > insert into EventUpdate (id,eventid,sequenceid) select ins.id,
> > ins.eventid,ins.sequenceid from inserted ins
>
> >bcp"select a.* from w..eventlog a, w..eventupdate b where
> >a.eventid=b.eventid and a.sequenceid=b.sequenceid and b.eventid<>-1
> >and b.sequenceid<>-1 and b.updatepass=1" queryout 30sec-%TFN_NOW%.wrk -
> >U <userwithaccess> -P <password> -S doserver -f EventLog.fmt
>
> TheBCPquery has a condition on the column UpdatePass which is not
> set in the trigger. So from what you have posted, I would not expect
> anything at all to go in theBCPfile.

sorry, i didn't clearly explain it. i did set the UpdataPass:

CREATE TABLE [EventLogUpdate] (
[id] [int] NOT NULL ,
[eventid] [int] NOT NULL ,
[sequenceid] [int] NOT NULL ,
[UpdatePass] [int] NULL
) ON [PRIMARY]
GO
create trigger trgEventUpdate on EventLog For Insert,Update as
insert into EventLogUpdate (id,eventid,sequenceid) select ins.id,
ins.eventid,ins.sequenceid from inserted ins
GO

[Back to original message]