How to increase the default row size in sql server 2000 only

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • pchadha20
    New Member
    • Oct 2006
    • 6

    How to increase the default row size in sql server 2000 only

    Hi, Guys.
    I am in bit trouble.I am importing the table from mysql to sql server which has having nearly 65000 records.
    I starts the import of table by import/export utility.But when the records reaches 65000, the error message came.."THIS TABLE HAVING ROW SIZE 8190 WHICH IS EXCCEDING THE DEFAULT SIZE OF 8060".
    So please let me know how to over come this problem..

    I CAN'T UPGRADE SQL SERVER SO GIVE SOLUTION FOR SQL SERVER 2000 ONLY...

    Thanks in Advance to all of you.

    pchadha20
  • Jogos
    New Member
    • Mar 2007
    • 4

    #2
    For my knowledge it isn't possible to change that limit. You should split your table or in some cases use Ntext-type but that would generate a lot of other troubles.

    Comment

    Working...