Ask a Question

Question

SQL Server Command String

25 pts.

Tags:

SQL Server security

What is the max length of the Command String that can be submitted to SQL Server?

Asked: December 21, 2007 3:40 PM Last updated: February 22, 2008 5:27 AM

There was an error processing your information. Please try again later.

Thanks. We'll let you know when a new response is added.

Send me notifications when members answer or reply to this question.

Denny Cherry 68,860 pts. · Accepted Answer · 2008-02-22T05:27:00+00:00

Thanks. We'll let you know when a new response is added.

The max size of a SQL Batch query is 65536 bytes.

If you are using dynamic SQL the max size of the command if 4000 characters as the data type must be NVARCHAR.