Is length of sql query limited in MS_SQL Server ?
Accoding to Books Online the maximum size of a query batch is 65,536 *
Network Packet Size (default 4KB).