thanks

thanks Much Sean i am going to test it now and let you know

thanks for your help

Bhuvnesh

Can anyone help on this

!!!!!!!!!!!!!!!!!

thanks sena . i dont need to worry about rest of the columns in those tables. i can add another column to specify whether its a string or num column...

thanks for your help

here is the structure of the src tables and other

Create table dbo.src

(

ID int Identity(1,1) PRIMARY KEY CLUSTERED

,Name varchar(100)

,Address varchar(255)

,Phone varchar(25)

,Age INT

)

insert into src values...

i am new bee let me try to provide actual requirement

Create table dbo.UpdateDef( SourceTableName VARCHAR(100),ColumnName VARCHAR(100),Status_fl CHAR(1))

go

insert into dbo.UpdateDef values ( 'dbo.Src','NAME','Y')

go

insert into dbo.UpdateDef values ( 'dbo.Src','ADDRESS','N')

go

insert into dbo.UpdateDef...

whatever specified in the adim table like customer and columns fname and lname status as Y

i want to build a update statement whatever specified in admin table

thanks, i will try that option. database doesnt have CDC or fk's defined.

both

But after dropping transactional replication keeping snapshot i am not able truncate the data from that table. In spahot we can always truncate.

does any one faced this type of error