Activity overview
Latest activity by bkuzma
Digging a litte deeper...
The SQL Compare software issues this query:
SELECT c.name AS name,
c.asymmetric_key_id as id,
p.name AS owner,
c.thumbprint AS ThumbPrint,
c.algorithm AS EncryptionAlgorithm,
c.pvt_key_encryption_type as EncryptionType,
c.key_length AS KeyLength
FROM sys.asymmetric_keys c
LEFT JOIN sys.database_principals p WITH (NOLOCK) ON p.principal_id=c.principal_id
In the process activity monitor, the process shows "AWAITING COMMAND" / comments
Digging a litte deeper...
The SQL Compare software issues this query:
SELECT c.name AS name,
c.asymmetric_key_id as id,
p.name AS owner,
c.thumbprint AS ThumbPrint,
c.algorithm AS EncryptionAlgorit...
Error while registering Databases
This error just started occuring, and I'm not quite sure why.
When running a comparison job, it will get to the "Reading Permissions" stage of "Registering Databases", then pause at 65%.
After a mi...