There is no query length limitation IN SQL Server. But there is a limit on Batch size
which is 65,536. This is network packet size on the Database Engine

Thanks Anith

"Al" <alfred@attenex.com> wrote in message
news:31e401c1efad$7b5e1ab0$9be62ecf@tkmsftngxa03.. .
> What is the max size (in bytes) of a SQL query allowed in SQL2000?
>
> Thanks, -Al

Thank you much.

>TEST--Original MessageTEST-- There is no query length limitation IN SQL Server. But
there
>is a limit on Batch size which is 65,536. This is network packet size on the
>Database Engine
>
>Thanks Anith
>
>"Al" <alfred@attenex.com> wrote in message
>news:31e401c1efad$7b5e1ab0$9be62ecf@tkmsftngxa03.. .
>> What is the max size (in bytes) of a SQL query allowed
in
>> SQL2000?
>>
>> Thanks, -Al
>
>
>.

You are right Linda. I did not do my research and was just quoting the number from
my memory.

Al, please take a note.

Thanks Anith

"lindawie" <lindawie@my-deja.com> wrote in message
news:#Qyrbs$7BHA.2260@tkmsftngp02...
> Anith,
>
> > There is no query length limitation IN SQL Server. But there is a limit on Batch
> > size which is 65,536. This is network packet size on the Database Engine
>
> Actually, this was true for versions earlier than 7.0. Refer to the topic Maximum
> Capacity Specifications in Books Online. The maximum batch size is listed as 65,536
> * Network Packet Size. The default packet size is 4K, so that's pretty big.
>
> Linda