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? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200882 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