Asym_Key_ID

Is the ID of an asymmetric key certificate in the database.

clear_text

Is clear text data that is being verified.

signature

Is the signature that was attached to the signed data. signature is varbinary.

int

Returns 1 when the signatures match; otherwise 0.

VerifySignedByAsymKey decrypts the signature of the data by using the public key of the specified asymmetric key, and compares the decrypted value to a newly computed MD5 hash of the data. If the values match, the signature is confirmed to be valid.

Requires VIEW DEFINITION permission on the asymmetric key.

A. Testing for data with a valid signature

SELECT Data,
     VerifySignedByAsymKey( AsymKey_Id( 'WillisKey74' ), SignedData,
     DataSignature ) as IsSignatureValid
FROM [Adventureworks].[SignedData04] 
WHERE Description = N'data encrypted by asymmetric key ''WillisKey74'''
GO
RETURN

B. Returning a result set that contains data with a valid signature

SELECT Data 
FROM [Adventureworks].[SignedData04] 
WHERE VerifySignedByAsymKey( AsymKey_Id( 'WillisKey74' ), Data,
     DataSignature ) = 1
AND Description = N'data encrypted by asymmetric key ''WillisKey74'''
GO

Reference

Other Resources

Help and Information