SQL Server 2000 error

Posted on 2009-12-21
Last Modified: 2013-11-24
I was trying to change the datatype of the column using query below:-

alter table Peak_trans alter column state_01 varchar(11)

so in the output i got

Warning: The table 'Peak_trans' has been created but its maximum row size (8062) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.

(12510 row(s) affected)

i have never seen this before. any highlight about this friends?
Question by:espanolanthony
    LVL 75

    Expert Comment

    by:Aneesh Retnakaran
    the maximum size of a  row in  sql server is 8060 bytes, in the case you try to populate more data it will fail. assuming that you trying to resize the column which will exceed the maximum size of the row
    LVL 1

    Author Comment

    so can i ignore it or anything that i have to do?
    LVL 41

    Expert Comment

    It is just a warning. If the size of data in your varchar columns (plus all fixed length columns) exceeds the maximum row capacity then it will raise error. Shorter data can be stored without problems.

    SQL Server 2005 does not have this limit because it stores long varchar data "out of rows".
    LVL 75

    Accepted Solution

    >so can i ignore it or anything that i have to do?
    yes, but its is goog practice to redesign the table
    LVL 1

    Author Closing Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    Via a live example, show how to shrink a transaction log file down to a reasonable size.
    The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now