SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Please Help Me ...
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

skiski
Starting Member

Iran
15 Posts

Posted - 05/27/2010 :  03:09:07  Show Profile  Reply with Quote
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

Edited by - skiski on 05/27/2010 03:12:23
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000