----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: VinodK [TLabs, SCT] Message 2 in Discussion Hi, Whew, a SQL Server question ... ... This is by design that SQL Server has this limitation. You cannot get over this using any shortcuts. This is because each data page is of this size and this is the most down to earth shortest entity size you have. This holds good for the Index also. But in Index you can have only 900 charaters long ... Now the next question is - Why did SQL Server allow me to create the table on first place. The answer is simple. You have created all the fields as Varchar hence SQL server cannot assume that you are going to have 8000 charaters or more in a single row. Hence it assumes that you will not exceed. But when you try to insert a value like this then it bombs, as it has in your case. How can I workaround this? This is also a simple solution ... 1. You can create multiple tables and store the data in multiple tables split across. OR 2. The second option used by many are using the text field instead of using a Varchar column. Now just a small explanation on why it is possible. It is to be understood that LOB (Large Objects) are stored away from the table data and just a pointer is placed in the table. But again for this there is something you are going to loose wrt the functionality. And a little bit of performance hit also ... The functionlaity is wrt the string functions you can use with Text columns Vs using them with Varchar columns. If you are going to Insert and then use this to retrieve the data to view the data then this is the simplest approach. I hope I've given you some direction on your problem ... HTH, Vinod Kumar Microsoft India Community Star www.extremeexperts.com ----------------------------------------------------------- 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]
