Remove the IDENTITY fields in the tables

During the creation of the publication, the IDENTITY fields are not replicated to the destination subscriber database, due to a constraint on fields with IDENTITY values and the intrinsic nature of those fields. You must change the state in the script for the following tables and fields:

• CatalogCustomCatalogs, CustomCatalogID
• CatalogDefinitions, DefinitionID
• CatalogGlobal, CatalogID
• CatalogStatus, StatusID
• CatalogName_CatalogProducts, oid

The following code example shows how to change the script:

CREATE TABLE [dbo].[CatalogCustomCatalogs] (

            [CustomCatalogName] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

            [CatalogName] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

            [CustomCatalogID] [int] NOT NULL ,

            [TimeStamp] [binary] (8) NOT NULL 

) ON [PRIMARY]

GO



CREATE TABLE [dbo].[CatalogDefinitions] (

            [DefinitionName] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

            [DefinitionID] [int] NOT NULL ,

            [DefinitionType] [int] NULL 

) ON [PRIMARY]

GO



CREATE TABLE [dbo].[CatalogGlobal] (

            [CatalogName] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

            [Locale] [int] NULL ,

            [StartDate] [datetime] NULL ,

            [EndDate] [datetime] NULL ,

            [VariantID] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

            [ProductID] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

            [Currency] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

            [WeightMeasure] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

            [TimeStamp] [binary] (8) NOT NULL ,

            [CatalogID] [int] NOT NULL ,

            [CustomCatalog] [bit] NULL ,

            [FreeTextIndexCreated] [datetime] NULL ,

            [ProductTableUpdated] [datetime] NULL ,

            [FullTextCatalog] [sysname] NULL ,

            [DefaultLanguage] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

            [ReportingLanguage] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

            [IsVirtualCatalog] [smallint] NULL ,

            [VirtualCatalogStatus] [smallint] NULL ,

            [CatalogFlags] [int] NULL ,

            [DisplayName_en-US] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL 

) ON [PRIMARY]

GO



CREATE TABLE [dbo].[CatalogStatus] (

            [StatusID] [int] NOT NULL ,

            [Operation] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

            [StartDate] [datetime] NOT NULL ,

            [EndDate] [datetime] NULL ,

            [Status] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

            [Result] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL 

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO



CREATE TABLE [dbo].[Hardware_CatalogProducts] (

            [CategoryName] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

            [oid] [int] NOT NULL ,

            [DefinitionName] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

            [IsSearchable] [smallint] NULL ,

            [cy_list_price] [money] NULL ,

            [UseCategoryPricing] [bit] NULL ,

            [TimeStamp] [varbinary] (8) NULL ,

            [OriginalPrice] [money] NULL ,

            [i_ClassType] [int] NULL ,

            [ParentOID] [int] NOT NULL ,

            [ProductID] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

            [VariantID] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

            [LastModified] [datetime] NOT NULL ,

            [CatalogName] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

            [PrimaryParentCategory] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

            [prodid] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

            [SKU] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

            [Image_filename] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

            [Image_height] [int] NULL ,

            [Image_width] [int] NULL ,

            [Benefits] [nvarchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

            [Features] [nvarchar] (4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

            [Licencetype] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

            [Manufacturer] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

            [Os] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

            [product name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

            [producturl] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

            [System Requirements] [nvarchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

            [Cordless] [nvarchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

            [ScrollWheel] [nvarchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL 

) ON [PRIMARY]

Go

Copyright © 2005 Microsoft Corporation.
All rights reserved.