Laurentiu Cristofor's blog @microsoft.com : July 2006

SQL Server 2005: How to determine what key was used to encrypt a piece of data: Let's say we have some data that is encrypted and we would like to find out what key was used to perform the encryption. SQL Server 2005 knows what key was used to encrypt the data because the key identifier (the key_guid value) is prefixed to the encrypted Read More...
Posted 06 July 06 04:23 by lcris | 1 Comments
Filed under SQL Server - cryptography, SQL Server, encryption
SQL Server 2005: How to regenerate the same symmetric key in two different databases: In a previous post on using symmetric keys , I mentioned that keys can be recreated using the KEY_SOURCE and IDENTITY_VALUE clauses of CREATE SYMMETRIC KEY. In this post, I'd like to expand a little on this topic and present a small demo as well. Because Read More...
Posted 06 July 06 03:26 by lcris | 9 Comments
Filed under SQL Server - cryptography, SQL Server, computer security, encryption

These posts are provided "AS IS" with no warranties, and confer no rights.

Laurentiu Cristofor's blog @microsoft.com