Very Computer

First let me tell you that I'm pretty new to sybase so this problem is
probablymy ignorance.

I have created a 10M device for our helpdesk database (development
purposes) I have create the database on that device. And now I tried to
export the original Access table into the helpdesk database over a
common Sybase ODBC and then I get this message: "Row size could exeed
size limit, wich is 1962 bytes"

I did'nt get that message when I first exported this exact table to the
master device! But I wanted to hold a seperate device for our data. So
that the master database can't be flooded and creates problems to dump
logs and run procedures.

What can I do to set the Row size higher? And what is the default of the
master device?

--
=====================
  Why use Windows
       When
     Real Men
Have Invented Doors?
=====================

        I'm not sure why you didn't get this message when you tried to
        load it into the master database, but there's nothing you can
        change on the server to alter the size. Its a limitation of the
        2K page sizes Sybase uses (in particular log pages). The best thing
        you can do is to examine your schema design, identify the errant
        table and try t* it down or splitting it up. Hint: look
        for varchar(255) columns are try redefining them to a more suitable
        size (i.e. varchar(80) etc.).

-am

Hello,
If you want to use table with columns bigger htan 1962 bytezs, you must use
the text type because the max size of a char (or varchar) is 255 characters.

Bye

Antinolfi Thierry
http://pro.wanadoo.fr/dbadevil

Raymond Doetjes a crit dans le message

Quote:>First let me tell you that I'm pretty new to sybase so this problem is
>probablymy ignorance.

>I have created a 10M device for our helpdesk database (development
>purposes) I have create the database on that device. And now I tried to
>export the original Access table into the helpdesk database over a
>common Sybase ODBC and then I get this message: "Row size could exeed
>size limit, wich is 1962 bytes"

>I did'nt get that message when I first exported this exact table to the
>master device! But I wanted to hold a seperate device for our data. So
>that the master database can't be flooded and creates problems to dump
>logs and run procedures.

>What can I do to set the Row size higher? And what is the default of the
>master device?

>--
>=====================
>  Why use Windows
>       When
>     Real Men
>Have Invented Doors?
>=====================