Skip to content

Default database for DAC  #7

Description

@martkopecky

If the user you are using for the DAC does not have the default database set to master, the SQL query "SELECT substring(crypt_property,9,len(crypt_property)-8) FROM sys.key_encryptions WHERE key_id=102 and (thumbprint=0x03 or thumbprint=0x0300000001)" returns empty resultset.

Please add catalog name to the from clause: ...FROM master.sys.key_encryptions ...

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions