----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: DotNetSaavy (Mr.BabuRaj) Message 1 in Discussion Guys, I have a small problem in SQL server, the problem is I am inserting/updating a table in SQL Server through ASP as the front end.On the ASP I have fifteen Textarea controls 3 of which accept 1000 chars and the rest of which accepts a maximum of 500 characters On click of "Save" button on the page,the values from all the 15 textarea must go into one table. I have MSDE (Microsoft SQL Server Desktop edition).I have designed the table as follows Create table TEST ( Field1 varchar(1000), Field2 varchar(1000), Field3 varchar(1000), Field4 varchar(1000), Field5 varchar(500), Field6 varchar(500), Field7 varchar(500), Field8 varchar(500), Field9 varchar(500), Field10 varchar(500), Field11 varchar(500), Field12 varchar(500), Field13 varchar(500), Field14 varchar(500), Field15 varchar(500)) 1) When I ran this query in Query analyzer I got a warning message as below Warning: The table 'TEST' has been created but its maximum row size (9552) 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. 2) When I tried to insert a record by filling up all the textarea to the max in the ASP I got a message as below [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot create a row of size 8117 which is greater than the allowable maximum of 8060. >From this it is clear that a row accepts only 8060 bytes in SQL server. Is there >anyway I can get rid of this problem and insert/update the records at the backend >without getting these messages. ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/BDotNet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
