• bilalhaider86 ,

    I'm not sure where you got those values from, but that article is about SQL2000 and you originally asked about SQL2005.

    Plus be careful when calculating the number of bytes per row, as SQL will store some data off-row if the on-row limit is reached - so whilst the spec says 8060 bytes per row, you can store more than that depending on the data types involved.

    The link for SQL2000 is http://msdn.microsoft.com/en-us/library/aa933149(SQL.80).aspx - and again the maximum number of rows is only limited by the available storage.

    Kev