>>>Whats the max size of a query (in bytes or characters) you can send to a sql server? I trying to find it in the help but Im having no luck. Any ideas?
>>>
>>>Eric Stephani
>>
>>Check Maximum Capacity Specifications in BOL.
>>Batch size = 65,536 * Network Packet Size (Default 4K)
>
>Isn't there an issue with the string size that can be sent thought SQLEXEC() or am I crazy?
>
>-Mike

I belive that ODBC driver imposes it's own limits. However original question didn't specify how query is sent to Sql Server. :)