Clever Geek Handbook

OLE DB provider "SQLNCLI11" for linked server failed to install INSERT

I have currently set up a linked server. We have two SQL Servers. Server B On server A, I created a linked server to server B

Now on Server A I have to do an insert on Server B DB. My chosen work is beautiful. Also I gave full access to user Below is the following error below.

OLE DB provider "SQLNCLI11" for linked server "serverB" returned the message "OLE DB multi-step actions generated errors. Check each OLE DB status value if available. Job failed."

Msg 7344 Level 16 State 1 Line 1 OLE DB provider "SQLNCLI11" for linked server "serverb" was unable to insert INSERT INTO into table "[serverb]. [Data]. [Dbo]. [Test]" due to column "test_ID". The user did not have write permission to the column

+3
sql


source to share


No one has answered this question yet

Check out similar questions:

3491
How can I UPDATE from SELECT in SQL Server?
2603
Add column with default value to existing table in SQL Server
1587
Insert multiple rows into one SQL query?
1504
Inserting Stored Procedure Results into a Temporary Table
1256
What are the options for storing hierarchical data in a relational database?
960
Insert into ... values ​​(SELECT ... FROM ...)
306
Cannot insert explicit value for identity column in table "table" if IDENTITY_INSERT is OFF
238
How do I create a foreign key in SQL Server?
126
How do I write UPDATE SQL with a table alias in SQL Server 2008?
0
DELETE request with INNER JOIN (on linked server)


More articles:


All Articles
Loading...
X
Show
Funny
Dev
Pics