Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: linked server in trigger

    like this??

    ALTER TRIGGER [TrgInsertTblExpedition] ON [dbo].[T_StockGudang]

    FOR INSERT

    AS

    declare @tes(20)

    select @tes = tes from inserted

    begin

    EXECUTE AS LOGIN = 'sa'

    insert into [10.1.0.13].gudang.dbo.TblExpedition (tes)

    VALUES(@tes)

    end

    it's not work, fox..

  • RE: linked server in trigger

    Mr. Lowell

    i did, i have setting DTC on both server

    -i have network DTC access checked

    -allow remote client,administrator checked

    -allow inbound checked

    it's drive me crazy...

    btw, thx for your idea,,

    but i...

Viewing 2 posts - 1 through 2 (of 2 total)