TDS Buffer Length Too Large - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

TDS Buffer Length Too Large

Author

Topic

Kleber
Yak Posting Veteran

67 Posts

Posted - 2006-03-13 : 13:38:59

Hi,

I am using sql server 2000 sp4, and when I run a certain query in query analyzer, it loads for a long time and then I receive the error messange: TDS Buffer Length too large.

I found some articles like: http://support.microsoft.com/default.aspx/kb/176256, but I don´t think it applies to my problem.

Any Idea?

Kleber
Brazil

The query is the following:
SELECT PANROPER,PANRPARC OPCODORG4,O4DESCR,PADTVCTO,PADTMOV,SUM(ISNULL(PAVLRPAGO,0)) AS VLR_PAGO,
SUM(ISNULL(PASLDXPR,0)+ISNULL(PASLDXJR,0)+ISNULL(PASLDXRAP,0)) AS VLR_SALDO_PARCELA,
SUM(ISNULL(PAVLRPR,0)+ISNULL(PAVLRJR,0)) AS VLR_PARCELA ,
DATEDIFF (DAY,PADTVCTO,PADTMOV) AS DIFERENCA_MOVIMENTO
FROM
COPER,CPARC,TORG4
WHERE
PANROPER=OPNROPER
AND
OPCODORG4=O4CODORG
AND
PACODMOV IN ('03','04','11')
AND
PADTMOV BETWEEN '2005/01/01' AND '2006/01/31'
AND
PADTLIQ IS NULL
AND NOT EXISTS (SELECT * FROM CPARC B WHERE PANROPER = B.PANROPER AND PANRPARC = B.PANRPARC AND B.PACNTRL > PACNTRL AND B.PACODMOV IN ('08''09'))
GROUP BY PANROPER,PANRPARC,OPCODORG4,O4DESCR,PADTVCTO,PADTMOV
ORDER BY OPCODORG4,O4DESCR,PADTMOV

Kristen
Test

22859 Posts

Posted - 2006-03-13 : 13:54:28

If you have SP4 on the Sever then presumably the server ADO drivers are up to date.

Are the ADO drivers on the client up to date?

Kristen