select encrypted data from another database

Question

select encrypted data from another database

my query is

select

(CONVERT(nVARCHAR(100),DECRYPTBYKEY(Tble.Name))) AS Name,

Tbl

.Code as Code

from

DbName..Tbl

i cant get encrypted data from Table Tbl

John Penn · Answer

-- First open the symmetric key with which to decrypt the data. OPEN SYMMETRIC KEY SSN_Key_01 DECRYPTION BY CERTIFICATE HumanResources037; GO -- Now list the original ID the encrypted ID and the -- decrypted ciphertext. If the decryption worked the original -- and the decrypted ID will match. SELECT NationalIDNumber EncryptedNationalID AS 'Encrypted ID Number' CONVERT(nvarchar DecryptByKey(EncryptedNationalID)) AS 'Decrypted ID Number' FROM HumanResources.Employee; GO

Suthish Nair · Answer

Abdu Why you creating duplicate post. Edit the existing thread only for any changes. http://www.c-sharpcorner.com/Forums/Thread/114082/select-query-for-encrypted-data-from-another-database.aspx

John Penn · Answer

You need to open the correct key first as in this example from MS: http://msdn.microsoft.com/en-us/library/ms181860.aspx