Post reply

Session (#) Temporary tables

  • May 3, 2002 at 5:44 am

    #158447

    I am getting the following error message. Is there a way to get around it?

    [Microsoft][ODBC SQL Server Driver][SQL Server]The total row size (8147) for table '#Temp_Pax_Data' exceeds the maximum number of bytes per row (8060). Rows that exceed the maximum number of bytes will not be added.

  • May 3, 2002 at 5:50 am

    #428419

    Not really. You probably have one or more char/varchar columns, try converting the largest one to text. Unless you have a very few rows you're better off trying to cut the width of the row considerably, it really hurts page io rates.

    Andy

    Andy
    Connect with me on LinkedIn

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply