Hi SSC, How to exclude a column in a table with Trasaction replication, and replicate only the remaining columns. My table schema is
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[IP_PERSON](
[PE_LOGN] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PE_IDEN] [smallint] NULL CONSTRAINT [DF_IP_PERSON_PE_IDEN] DEFAULT ((0)),
[PE_EMID] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PE_NAME] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
**[PE_LOPW] [varbinary](15) NULL,**
[PE_DEPT] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PE_DESG] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PE_JOIN] [datetime] NULL,
[PE_QUIT] [datetime] NULL,
[PE_CRDT] [datetime] NULL,
[PE_MODT] [datetime] NULL,
[PE_CRBY] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PE_MOBY] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PE_PSWD] [varbinary](15) NULL,
[PE_PTYP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_IP_PERSON_PE_PTYP] DEFAULT ('0'),
[PE_MAIL] [varchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PE_MCTC] [int] NULL CONSTRAINT [DF_IP_PERSON_PE_MCTC] DEFAULT ((0)),
[CU_IDEN] [smallint] NULL CONSTRAINT [DF_IP_PERSON_CU_IDEN] DEFAULT ((0)),
[PE_LOCN] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PE_ARCH] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_IP_PERSON_PE_ARCH] DEFAULT ('0'),
[PE_PROX] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PE_LMGR] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL CONSTRAINT [MSmerge_df_rowguid_042CC70CF90D43C69698564EC357D66D] DEFAULT (newsequentialid()),
CONSTRAINT [PK_IP_PERSON] PRIMARY KEY CLUSTERED
(
[PE_LOGN] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF.
I had bold the column whose data need not to be replicated. Kindly guide me in getting this done.
asked
Dec 09 '11 at 02:56 AM
in Default
Mohanraj
1
●
1
●
1