• Thanx for the reply. I did the same on the same server but its not working. Actually i wanted to do the same on two different Sql server. My one Database Server is server1 and another one is Server2.One database present on server1 and other is on server2.Following is My query.

    CREATE TRIGGER trigger1 ON Document after Update AS

    begin

    INSERT INTO [TEST].[dbo].Document_Log(ID,InwardID,RetrievalID,UnitID,DepartmentID,DocumentType,

    DocumentCriticality,AdditionalInfo1,AdditionalInfo2,AdditionalInfo3,DocAccRelated,AccountNumber,

    CustomerName,TransactionDateFrom,TransactionDateTo,DocCategory,DocClosingDate,ProposedDestructionDate,

    CheckerDestructionDate,

    SuperCheckerDestructionDate,

    DocumentStatusID,

    DocumentName,

    Location,

    StorageVendor,

    BoxBarcode,

    IsRefiled,

    ReinventoryStatus,

    DateofDispatch,

    AdditionalDispatchDetails,

    FileBarcode,

    InwardDate,

    RetrievalDate,

    LostStatus,

    CreatedOn,

    CreatedBy,

    UpdatedOn,

    UpdatedBy) ---- this is required otherwise will get error.

    SELECT ID,InwardID,RetrievalID,UnitID,DepartmentID,DocumentType,

    DocumentCriticality,AdditionalInfo1,AdditionalInfo2,AdditionalInfo3,DocAccRelated,AccountNumber,

    CustomerName,TransactionDateFrom,TransactionDateTo,DocCategory,DocClosingDate,ProposedDestructionDate,

    CheckerDestructionDate,

    SuperCheckerDestructionDate,

    DocumentStatusID,

    DocumentName,

    Location,

    StorageVendor,

    BoxBarcode,

    IsRefiled,

    ReinventoryStatus,

    DateofDispatch,

    AdditionalDispatchDetails,

    FileBarcode,

    InwardDate,

    RetrievalDate,

    LostStatus,

    CreatedOn,

    CreatedBy,

    UpdatedOn,

    UpdatedBy

    from inserted

    end

    I m getting an error as

    Msg 208, Level 16, State 1, Procedure trigger1, Line 4

    Invalid object name 'TEST.Document_Log'.

    I tried this on the same server by making replica of database2 on the same server. But same is not working on one server then how it will work on different server. Please Suggest me something so that i can do the same on two different server.

    Thanks...