Skip to content

Default database for DAC  #7

@martkopecky

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
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions