I keep getting an error that states I cannot insert explicit value for itentity column in table 'Users' when IDENTITY_INSERT is set to off, can anyone help?
Code:/****** Object: Table [dbo].[Users] Script Date: 5/6/2010 10:48:47 AM ******/ if not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Users]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) BEGIN CREATE TABLE [Users] ( [UserID] [numeric](18, 0) IDENTITY (1, 1) NOT NULL , [NTAccount] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Active] [bit] NULL , [UserChanged] [bit] NULL , [UserAgreeDate] [datetime] NULL , [AFSC] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [AFSC2] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [DutyTitle] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [UserName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Password] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [GroupID] [int] NULL , [FirstName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [LastName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [NickName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [LastLogin] [datetime] NULL , [WingStructure] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [BioImage] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [LongDistancePIN] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [MilitaryRank] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [OfficeExtension] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [SmallImage] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [OfficeFAX] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [WorkStatus] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [IsAdmin] [bit] NULL , [LastUpdate] [datetime] NULL , [EMailAddress] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , CONSTRAINT [PK_Users] PRIMARY KEY NONCLUSTERED ( [UserID] ) WITH FILLFACTOR = 90 ON [PRIMARY] ) ON [PRIMARY] END GO


Reply With Quote



Bookmarks