# Mssql bulk linked server

**URL:** <https://discourse.nodered.org/t/mssql-bulk-linked-server/88600>\
**Category:** General\
**Created:** [10 June 2024 11:53 UTC](https://discourse.nodered.org/t/mssql-bulk-linked-server/88600 "2024-06-10T11:53:58Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![TomasVera](https://avatars.discourse-cdn.com/v4/letter/t/e5b9ba/32.png) [@TomasVera](https://discourse.nodered.org/u/TomasVera)\
**Post date:** [10 June 2024 11:53 UTC](https://discourse.nodered.org/t/mssql-bulk-linked-server/88600/1 "2024-06-10T11:53:58Z")

</div>

Hi all,

We're trying to bulk save with the MS-SQL node to a linked server, any idea?  
Normal inserts work flawlessly, and saving onto a local server with the same configuration works as well.  
Thanks in advance.

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/b/d/bd88b1a8dbed9d97995284aec8e2460c67f7328e.png)

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [10 June 2024 12:38 UTC](https://discourse.nodered.org/t/mssql-bulk-linked-server/88600/2 "2024-06-10T12:38:46Z")

</div>

Have you tried the built in bulk insert demo?

`ctrl-i` -\> examples

Or source: [node-red-contrib-mssql-plus/examples/Bulk demo.json at master · bestlong/node-red-contrib-mssql-plus · GitHub](https://github.com/bestlong/node-red-contrib-mssql-plus/blob/master/examples/Bulk%20demo.json)

EDIT

to be more specific, have you got bulk insert working with non linked tables? That would be my first approach.

I have never tested bulk insert against linked servers.

EDIT2

- set the mssql node option Return driver output
- Add a debug node to mssql node output (set to show FULL msg)
- Expand all properties and show us what you see

---

<div class="post-metadata">

**Author:** ![TomasVera](https://avatars.discourse-cdn.com/v4/letter/t/e5b9ba/32.png) [@TomasVera](https://discourse.nodered.org/u/TomasVera)\
**Post date:** [10 June 2024 13:25 UTC](https://discourse.nodered.org/t/mssql-bulk-linked-server/88600/3 "2024-06-10T13:25:18Z")

</div>

Thanks for the reply.

I got the bulk insert working with non linked tables, I made a copy of the same table on my own computer and it works 100%, just what I wanted, but not working for linked server.

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/3/e/3e2ee1a90696a0f9bd5f26af029cd535fcd1d2ed.png)  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/a/3/a37cb76f62872137f85235a6771f296347a99d9c.png)

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [10 June 2024 16:02 UTC](https://discourse.nodered.org/t/mssql-bulk-linked-server/88600/4 "2024-06-10T16:02:51Z")

</div>

Does the user setup in node-red MSSQL config have permission to access the linked server and appropriate permission for the table?

Failing that, you might need to use the TVP method (demo [here](https://github.com/bestlong/node-red-contrib-mssql-plus/blob/master/examples/TVP.json))

Using TVP (table valued parameters) you can perform operations from within a stored procedure on the local server to your remote sql server.

---

<div class="post-metadata">

**Author:** ![TomasVera](https://avatars.discourse-cdn.com/v4/letter/t/e5b9ba/32.png) [@TomasVera](https://discourse.nodered.org/u/TomasVera)\
**Post date:** [13 June 2024 08:01 UTC](https://discourse.nodered.org/t/mssql-bulk-linked-server/88600/5 "2024-06-13T08:01:30Z")

</div>

Finally we're saving bulk to local server with a trigger to remote server. Thanks!!

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [11 September 2024 08:02 UTC](https://discourse.nodered.org/t/mssql-bulk-linked-server/88600/6 "2024-09-11T08:02:31Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.