Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Transact-SQL (2000)  Please Help Me ...

Author  Topic  skiski Starting Member 15 Posts Posted - 2010-05-27 : 03:09:07 if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tbl_DocumentsRow]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tbl_DocumentsRow] GO CREATE TABLE [dbo].[tbl_DocumentsRow] ( [fldID] [bigint] IDENTITY (1, 1) NOT NULL , [fldXld] [tinyint] NOT NULL , [fldVAH_Code] [nvarchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [fldSal] [int] NOT NULL , [fldMAN_Code] [int] NOT NULL , [fldSerialNo] [bigint] NOT NULL , [fldRow] [int] NOT NULL , [fldDocDt] [nvarchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [fldGenCodeE] [nvarchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [fldSubCodeE] [nvarchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [fldChiCodeE] [nvarchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [fldGenCode] [nvarchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [fldSubCode] [nvarchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [fldChiCode] [nvarchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [fldDescX] [nvarchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [fldDesc] [nvarchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [fldAmount] [bigint] NOT NULL , [fldAmountCode] [tinyint] NOT NULL , [fldAmountX] [bigint] NOT NULL , [fldElamyeNo] [int] NOT NULL , [fldGrpCodeM] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [fldTypeM] [tinyint] NULL , [Eftetah] [tinyint] NULL , [Ekhtetam] [tinyint] NULL , [Sood] [tinyint] NULL , [fldGrpCodeE] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [fldTypeE] [tinyint] NULL ) ON [PRIMARY] GO The index entry of length 909 bytes for the index "IX_tbl_DocumentsRowDesc" exceeds the maximum length of 900 bytes. Thanks