I am trying to lookup a dialog from conversation_endpoints, however if a dialog was created with the encryption setting to ON and thereis no master Key in the database then the record put in the conversation_endpoints is the same as one without encryption.
How can I distinguish between the one requested with no ecryption and requested with encryption but setup with none due to the lack of a key?
There is no way to find out looking only at the sys.conversation_endpoints table. But if you request encryption and there is no master key, the messages will stay pending with status set to 'The session keys for this conversation could not be created or accessed. The database master key is required for this operation.' in the sys.transmission_queue.
|||Thats what I guessed, shame really
No comments:
Post a Comment