August 31, 2011 at 8:48 am
I think that this is because you are using the option KEY_SOURCE. If you use this option, then you get the same key. The certificates on each database encrypts the key, but don’t change the way that the key encrypts the data.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 31, 2011 at 9:21 am
Adi Cohn-120898 (8/31/2011)
I think that this is because you are using the option KEY_SOURCE. If you use this option, then you get the same key. The certificates on each database encrypts the key, but don’t change the way that the key encrypts the data.Adi
Hi Adi, Thank you for the reply, removing the KEY_SOURCE has cured the problem.
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply