encrypt a column only on the subscriber

• Aspet Golestanian Namagerdi

  SSCarpal Tunnel

  Points: 4444

  More actions

  March 14, 2011 at 3:06 pm

  #233240

  Hi Guys,

  Our Databases are in SQL SERVER 2008. We have transactional Replication with two subscriber.There are some Columns(Like SSN) that we want to Encrypt them in subscriber side only.We can not encrypt them on Production side(Because some third party applications are using them).Is there any way to do that.

  Thanks in advance for your help.

• sturner

  SSC-Insane

  Points: 22411

  More actions

  March 14, 2011 at 3:19 pm

  #1298588

  Not from SQL server directly. What you can do is just to NOT replicate the SSN column to the subscribers.

  The probability of survival is inversely proportional to the angle of arrival.