Maximum Capacity Specifications SQL 2000

• Kyle-771813

  Old Hand

  Points: 374

  More actions

  September 15, 2008 at 10:03 am

  #127403

  I need some help! 😀

  I was running a search program I wrote and I got this message:

  [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot sort a row of size 8178, which is greater than the allowable maximum of 8094.

  I looked on MSDN (http://msdn.microsoft.com/en-us/library/aa933149(SQL.80).aspx) and I was wondering if this is a default value that could be changed to compensate for the extra length?

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738643

  More actions

  September 15, 2008 at 10:04 am

  #871861

  Don't cross post.

  Answered here: http://www.sqlservercentral.com/Forums/Topic569582-8-1.aspx