Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language

Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

Sql Server Programming

Encrypt columns, Size question in SQL2005

Hello all,

I've been doing a lot of research on column encrypting/decryping in SQL
Server 2005.  I definitely understand it a lot better than I did, but I'm
still hazy on some issues.

If I have a column which is normally char(9) (say for storing an SSN), with
encryption, I need this column to be of type varbinary.  Correct?
However, how do I determine the necessary length of the varbinary?

Any one have any good tutorials about encryption with SQL2005?

Here's basically what I'm trying to accomplish:
1) ASP.NET2/C# webform accepts a 9-digit field for SSN
2) webform calls a SQL2005 stored proc which has a char(9) parameter for the
3) In the stored proc, encrypt the char(9) SSN and store it in the necessary
4) And at some point later, a user with appropriate authority can login and
call a stored proc which will return the decrypted char(9) ssn.

It doesn't seem terribly difficult, but I haven't had much
luck/understanding what I've found on google and msdn.


Hello Brian,

I understand that you want to know how to encrypt the column data.

You could follow this MSDN article to use the synmetic key

How to: Encrypt a Column of Data

Hope this helps.


Wei Lu
Microsoft Online Community Support


When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

This posting is provided "AS IS" with no warranties, and confers no rights.

Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc