Problem From Scripted Tables - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Problem From Scripted Tables

Author

Topic

Pace
Constraint Violating Yak Guru

264 Posts

Posted - 2005-03-21 : 04:34:59

Hey all,

I have generated a sql script that will create all my tables for me.

However I get the following error when I run the script in QA;

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

does anyone know how I can correct this ?

Thanks,
Pace

when life hands you lemons, ask for tequila and salt

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-03-21 : 04:38:20

shorten that large varchar column

Go with the flow & have fun! Else fight the flow

Pace
Constraint Violating Yak Guru

264 Posts

Posted - 2005-03-21 : 04:46:33

No way...

someone has seen this before

thanks again, thats both times I have been stuck you saved me

when life hands you lemons, ask for tequila and salt

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-03-21 : 05:04:07

i guess it worked

varchar(8000) is practicaly applicable only if you have that column + int PK.
other wise you go over the 8060 row size limit preety fast.

Go with the flow & have fun! Else fight the flow

Pace
Constraint Violating Yak Guru

264 Posts

Posted - 2005-03-21 : 05:12:05

quick you need 1 more post

when life hands you lemons, ask for tequila and salt

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-03-21 : 05:23:12

happy?