I'm trying to insert some rows from local table, to a remote table.
begin distributed tran begin try insert into [ali\servername].[dbname].[dbo].[mytable] select col1, col2 from mytable; commit end try begin catch print 'fail' rollback tran end catch
But I get this error :
OLE DB provider "SQLNCLI11" for linked server "ali\servername" returned message "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done."
I found this article but there is no way to fix problem in SSMS. Anyone can help?
Thanks in advance.