|
|
|
Valued Member
 
Group: General Forum Members
Last Login: Monday, March 08, 2010 5:03 AM
Points: 56,
Visits: 97
|
|
Hi 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ül
|
|
|
|
