Post reply

maximum allowed size

  • August 1, 2007 at 8:28 am

    #174010

    Hi everyone,

    I got an error using SQL 2000 regarding to a data column size I tried to create,with the message:

    "The size (8192) given to the column 'signature' exceeds the maximum allowed for any data type (8000)."

    Is it possible to change the max size of this limit or it is permanent limitation?

    If so where can I do that?Sorry for an easy question, but I am in real need of the answer.

    Thanks in advance.

    Ben

  • August 1, 2007 at 9:03 am

    #723904

    You have mentioned SQL 2000 but have posted this in SQL 2005. In SQL 2005, use can use VARCHAR(MAX). In SQL 2000, you have will to change the datatype to text.

     

  • August 1, 2007 at 2:26 pm

    #723997

    ooops Sql Junkie

    You are right, just missed the right forum.I usually use SQL 2005, but have to use now SQL 2k and just placed my message in the wrong place.

    Thanks for your advice, appreciated.

    Cheers

    Ben

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

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