Linked Servers And Columnstore

Niko Neugebauer continues his columnstore series by looking at how they interact with linked servers:

Lets us make sure everything is fine for data transfer and as we are using our source server (SQL Server 2014) with Linked Server to SQL Server 2016, let us insert a couple of ObjectIds to the T1 table that we have created in the [Test] database:

1 2 3

INSERT INTO [.\SQL16].Test.dbo.T1 (C1) SELECT so.object_id FROM sys.objects so;

This statement will result in the error message that you can find below, telling us something about Cursors (????):

1 2	Msg 35370, Level 16, State 1, Line 1 Cursors are not supported on a table which has a clustered columnstore index.

WHAT ? SORRY ? THERE ARE NO CURSORS HERE !
We have no cursors, we just have a Clustered Columnstore Index on our table!

Read on to see how to get around this error, to the extent that you can.