----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: SriSamp Message 3 in Discussion The row size of SQL Server is 8060 bytes. Thus your table creation script has to keep this in mind. For your current problem, there are multiple ways you can get around the error: [A] From your table creation code, how did you arrive at the values 1000 and 500?? Are these well known data lengths?? If not, you can try reducing these values to lesser lengths so that SQL Server does not give you this error/warning. [B] SQL Server supports a data type called TEXT, which when used, is actually a 16-bit pointer to a set of data pages that can hold upto 2GB of data. You can convert some of your columns to TEXT data types so that this error is not given, but remember that TEXT data types are an overhead and induce some performance issues. [C] Normalize your table so that you have a 1:1 master-child relationship. This way, your ASP page can still represent the data as a whole, but your INSERT can span multiple tables. You can probably create a view to abstract the fact that you have a master-child table and query off that view. The bottom line is that you need to clearly decide on the width of data types and it is recommended that you keep your data types as narrow as possible. HTH, SriSamp MVP - SQL Server ----------------------------------------------------------- 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]
