Max Query Length in Yukon

• shrikant-279400

  SSCommitted

  Points: 1651

  More actions

  December 21, 2005 at 6:42 am

  #96081

  Hi

    What is max query length in yukon? 

     In SQL 2000 its batch Size * network packet size (4096 Bytes default and  can be change using sp_configure)

   Is this same in SQL 2005 ?  what happens if query length more than 256 MB ?  How it handles nvarchar(max) if I declare a dynamic sql string in it and string length exceeds this limit ?

   

   

   

  Regards
  Shrikant Kulkarni

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736212

  More actions

  December 21, 2005 at 9:38 am

  #610895

  http://msdn2.microsoft.com/en-us/library/ms143432.aspx