Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Linked Server Raw Data Size Limit? Expand / Collapse
Author
Message
Posted Friday, August 19, 2011 11:31 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, January 14, 2014 4:18 PM
Points: 205, Visits: 641
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
Posted Wednesday, October 24, 2012 1:55 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, January 19, 2014 9:56 AM
Points: 7, Visits: 183
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 »

Add to briefcase

Permissions Expand / Collapse