Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Encrypt & Decrypt table column ( ssn int, b_date) Expand / Collapse
Author
Message
Posted Thursday, July 14, 2011 12:54 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, November 6, 2014 9:55 PM
Points: 157, Visits: 846
HI

Any any one could you help me..

Encrypt the two column in table. in sql server 2005

Example :

Table Name: Accont

colum : ssn int, bdate date

need two column encryption with certifcate level..


Help me

Thaks
Jerry

Post #1141497
Posted Thursday, July 14, 2011 1:11 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, February 18, 2013 3:46 AM
Points: 1,422, Visits: 1,883
The links below have sample scripts on how to encrypt data in SQL Server 2005:

http://blogs.msdn.com/b/lcris/archive/2005/06/09/simple-demo-for-how-to-encrypt-and-decrypt-a-table-column-in-sql-server-2005.aspx

http://blogs.msdn.com/b/lcris/archive/2005/06/10/sql-server-2005-column-encryption-demo-part-2.aspx

http://blogs.msdn.com/b/lcris/archive/2005/12/16/sql-server-2005-yet-another-column-encryption-demo-quot-clinic-quot.aspx




Post #1141504
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse