InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 03:34:09 GMT20http://www.sqlservercentral.com/Forums/Topic1406617-359-1.aspxNo worries no this.All I did was open the DMK and then regenerate using the original password.I'm able to decrypt the data now.AndrewMon, 14 Jan 2013 09:35:52 GMTAndrew Pruskihttp://www.sqlservercentral.com/Forums/Topic1406617-359-1.aspxHello,I would like some advice on cell based encryption please.I have transferred a database which uses a certificate to encrypt certain data from a live server to a newly built server.Now that the database is on a new server, the DECRYPTBYCERT function only returns null values when applied to the encrypted data. Please could someone confirm the best way to re-enable the function?The steps I think I should take are:-1. Backup Database Master Key on original server2. Transfer backup to new server3. Restore DMK using Server Master KeyAny help would be most appreciated.Regards,AndrewMon, 14 Jan 2013 02:52:35 GMTAndrew Pruski