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...