InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 24 May 2012 13:15:42 GMT20http://www.sqlservercentral.com/Forums/Topic833313-338-1.aspxHi All,I try to write a trigger which is updated a table in an other Server and Database. I use OPENDATASOURCE for this.But I don't know the correct syntax for it.INSERT INTO OPENDATASOURCE('SQLOLEDB','Data Source=(local)').[DataBase].[dbo].[InsertedTable]([col1],[col2]) When I executed the script above,I taken an error below,[color=OLE DB provider "SQLNCLI" for linked server "(null)" returned message "Invalid authorization specification". Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "SQLNCLI" for linked server "(null)" reported an error. Authentication failed. Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "SQLNCLI" for linked server "(null)".][/color]Can you help me?Kind Regards AyşegülSat, 12 Dec 2009 03:25:03 GMTaysegul