SQL Server Performance Forum – Threads Archive
Depryting returns a NULL value
<br />I find it weird when decrypting a column from a copied table in another database. Here’s the scenario:<br /><br />Instance1 has Database1 and Database2.<br />Database1 has Table1 with two columns encyrpted — Card Number and SS Number<br />Encryption and decryption in this Database1 is perfectly fine. Records are encrypted and can be decrypted too.<br />Now, I tried coping this Table1 to Database2 using the SELECT command. Of course the columns Card and SS Numbers were encrypted. I tried decrypting the columns using the same command to decrypt in Database1, however, it returns a NULL value <img src=’/community/emoticons/emotion-6.gif’ alt=’![Frown :( :(](styles/default/xenforo/smilies/frown.png)
<br />I tried also the following:<br /><br />Backup the database1, restore it to another database instance on another SQL server 2005. Create certificate and symmetric keys, but it didnt work as well <img src=’/community/emoticons/emotion-6.gif’ alt=’
![Frown :( :(](styles/default/xenforo/smilies/frown.png)
Check the following.. http://blogs.msdn.com/lcris/archive/2005/12/16/504692.aspx
http://msdn.microsoft.com/msdnmag/issues/05/06/SQLServerSecurity/default.aspx MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
]]>