question

rehaan avatar image
rehaan asked

I want to change size of a column at subscriber table in Transactional Replication

Hi friends, I am working on Transactional Replication. I have requirement to increase the size of a column for few tables at subscriber then I will encrypt it with guid At publisher create table test (col1 varchar(20), col2 varchar(20)) At subscriber Create table test (col1 varchar(100),col2 varchar(100)) I want to increase the size of datatype at subscriber and then add some custom logic to the column for which am increasing the size in the sproc CALL [sp_MSins_dbotest] I want to apply snapshot with this change. How can i do this. Any help would be much appreciated
transactional-replicationsnapshot
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
sjimmo avatar image
sjimmo answered
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.