An NVarChar of 4000 characters requires 8000 bytes storage space (VarChar would require 4000). The maximum amount of data you can put in a single row is 8060 bytes, excluding large fields like text, ntext, blob, clob....
An easy fix would be to just make the description field a little smaller, e.g. 3000. -----Original Message----- From: ColdFusion Developer [mailto:[EMAIL PROTECTED] Sent: Thursday, 31 March 2005 2:35 p.m. To: CF-Talk Subject: Re: SQL Script I know this is MS SQL Server related but for a CF app. I have a SQL script that creates the following table but produces the following warning. Any idea what this means and how I can get around it? CREATE TABLE [dbo].[FILE_CATEGORY] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [CATEGORY] [nvarchar] (150) NULL , [DESCRIPTION] [nvarchar] (4000) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[FILE_LISTINGS] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [FileName] [nvarchar] (50) NULL , [FileDescription] [nvarchar] (2000) NULL , [FileLocation] [nvarchar] (4000) NULL , [CategoryID] [int] NULL ) ON [PRIMARY] GO The total row size (8329) for table 'FILE_CATEGORY' exceeds the maximum number of bytes per row (8060). Rows that exceed the maximum number of bytes will not be added. The total row size (12135) for table 'FILE_LISTINGS' exceeds the maximum number of bytes per row (8060). Rows that exceed the maximum number of bytes will not be added. Why would I get this? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200883 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
