Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language


 
 
Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

Sql Server Programming

Error in CREATE TABLE


Hi,

I have a SQL statement as below:

CREATE TABLE SystemParameter
        (SystemParameterID DTTypeID,
        SystemParameterName DTOptionName,
        SystemParameterValue DTOptionValue,
        AgentID int,
        Threshold int,
        CheckOrNot int,
        ErrorText DTObjectDescription)

But I've got error as below:

Warning: The table 'SystemParameter' has been created but its maximum
row size (9141) 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.

Anything wrong with the CREATE TABLE statement?

> Anything wrong with the CREATE TABLE statement?

There is nothing syntactically wrong.  The row length warning means that the
variable row length could potentially exceed the maximum size.  If you later
attempt an INSERT/UPDATE that exceeds the max size, the insert/update will
fail.

You didn't provide the UDT definitions but it is likely that underlying data
types have a large maximum size.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Curious" <fir5tsi@yahoo.com> wrote in message

news:1181098760.810712.236860@q66g2000hsg.googlegroups.com...

Thanks Dan! I changed definition of one column to a smaller varchar
type, and the query went through.
Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc