Is there a standard Stored Procedure or Function that will decrypt fields in RE and/or FE? We have several web tie-ins that query the FE database directly, and some of these fields are now encrypted since the last update we ran.
Hey Sean,
So I'm not too familiar with FE and RE as we use BBCRM ourselves but I'm hoping that the encryption/decryption methodology is similar between the three.
So CRM uses a stored procedure to retrieve a unique key associated with your database:
USP_GET_KEY_ACCESS
Once you execute that you have to call the following:
CONVERT(nvarchar(4000), DECRYPTBYKEY(TABLE.COLUMN))
Above, TABLE.COLUMN represents the column you're attempting to decrypt.
After that you just include the following line to get rid of the key when you're done:
CLOSE SYMMETRIC KEY SYM_BBINFINITY
Again, this is in reference to CRM but maybe it will give you at least something to work off of. Sorry I can't be of more help.
