OPENQUERY throwing "Out of memory" error: limit rows until all are loaded
|Added at||2016-12-30 09:12|
In SQL Server 2016 I have a stored procedure. In this SP I want to get all data from a view from a linked server (PostgreSQL) by using the following statement:
When I use it like this, I'm getting the following error message after a few minutes:
I changed the
Now I am unsure what the most practical way to get all data would be. I could insert the first 1000000 rows and then insert the next 1000000 using
Any help would be appreciated.