Linked Server Raw Data Size Limit?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Linked Server Raw Data Size Limit?

Linked Server Raw Data Size Limit?

Rate Topic

Display Mode

Topic Options

Author

Message

SwedishOrr

Posted Friday, August 19, 2011 11:31 AM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, September 13, 2012 3:25 PM
Points: 205, Visits: 640

Is there a limit to how many bytes of data can be returned over a linked server? If so, is it configurable?

Quick example of what I'm seeing:

From Server A:

SELECT DATALENGTH(col1) FROM [RemoteServer].[Database].dbo.[Table] WHERE ID = 1971118 
-- 1132

SELECT DATALENGTH(col1) FROM [RemoteServer].[Database].dbo.[Table] WHERE ID = 1969881
-- 0

From Server B:

SELECT DATALENGTH(col1) FROM [RemoteServer].[Database].dbo.[Table] WHERE ID = 1971118   
-- 1132  
  
SELECT DATALENGTH(col1) FROM [RemoteServer].[Database].dbo.[Table] WHERE ID = 1969881  
-- 93560512

I'm trying to figure out why Server A is returning 0 for the second query. The Linked servers are set up the exact same way. Both servers are SQL Server 2005 SP3, Enterprise Edition (Server A is 32 bit, Server B is 64 bit; I get the same results as Server B on another 32 bit machine, though that one runs SQL2K5 SP4).

What are some of the reasons this could be happening?

Post #1162697

kat 70972

Posted Wednesday, October 24, 2012 1:55 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 10:37 AM
Points: 7, Visits: 133

Did you ever figure this out? Seeing the exact same thing and can't find any documentation on it!

Post #1376651

« Prev Topic | Next Topic »

Permissions