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
 SQL Server Administration (2005)
 sharing security certificate

Author  Topic 

ujjaval
Posting Yak Master

108 Posts

Posted - 2007-05-20 : 19:42:51
Hi,

I have a database where one of my table is encrypted using the security certificate in sql server 2005 for that database. Now, I am transferring encrypted data into another column in another database on the same server. How can I use the security certificate from the original database into this database to decrypt the encrypted data?

It may sound wierd, but I need to do this.

Thanks,
Ujjaval
   

- Advertisement -