Comments
Sort by recent activity
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...