Post reply

data encryption in SQL Server 2005

  • March 31, 2008 at 3:34 pm

    #128398

    Hi everyone, I am a Sybase dba working in transition to to SQL Server. One of my project is to setup data encryption on a database in SQL Server 2005. Some of the columns I need to work with have data types of integer, decimal etc....(numeric data values). At this point, I can't find any examples that have data encryption on numberic data type. If you know how to do it, please help !!!!

    thanks milliions.

  • March 31, 2008 at 5:12 pm

    #796213

    When you encrypt a value, it's going to end up being sqlbinary as a data type. That's why the examples show the encrypted columns as sqlbinary. And when you decrypt, you will need to use CONVERT to get back to the correct datatype. If you look at any of the examples from Books Online, they are converting to nvarchar, but the principles are the same.

    K. Brian Kelley
    @kbriankelley

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply