Post reply

SQL Server 2008 Express Text Field Limit

  • October 8, 2011 at 9:31 am

    #390571

    Greetings, I have a pos application that is connected to a SQL Server 2008 R2 Express database. The application gives our sales staff the ability to keep notes on their clients. Lately we are running into an application error when the notes field reaches a certain capacity (data length 8000). Is there a way to increase the amount of data the text field can contain?

    If it is not possible to increase the text field limit, I am also considering upgrading to MS SQL Server 2008 R2 for Small Business. If I make the upgrade will this solve the text field limitation and end my application error?

    Thank you for your help!!

    Jason

  • October 8, 2011 at 3:05 pm

    #1392111

    I've not used SQL Server Express but I'm pretty sure it will all for the use of VARCHAR(MAX) which will give you capabilities up to 2 billion characters (1 billion if you use NVARCHAR(MAX)).

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • October 8, 2011 at 3:32 pm

    #1392117

    Thanks Jeff!

    I will give that a shot and see what happens. I appreciate your input.

    Jason

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

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