Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 DecryptByKeyAutoCert issue

Author  Topic 

Hashimoto
Starting Member

1 Post

Posted - 2010-09-14 : 15:18:29
Hi, new here.

I'm having a sudden problem with the function DecryptByKeyAutoCert.

I have encrypted data that is decrypted using a specific certificate and associated symmetric key. It's all been working fine when retrieving this piece of data until today.

DecryptByKeyAutoCert returns a NULL when there is actually a value inside the column.

Any idea what could be causing this and how to fix it?

Thank you.
   

- Advertisement -