Skip to content

Instantly share code, notes, and snippets.

@mikerodionov

mikerodionov/Check_encryption_with_DB_key.sql

Created January 17, 2019 16:35
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mikerodionov/eee617f573655f64a60bc274d9b82a10 to your computer and use it in GitHub Desktop.
Save mikerodionov/eee617f573655f64a60bc274d9b82a10 to your computer and use it in GitHub Desktop.
Download ZIP
SQL Encryption Test
Raw
Check_encryption_with_DB_key.sql
USE K2
OPEN SYMMETRIC KEY [SCSSOKey]
DECRYPTION BY CERTIFICATE SCHostServerCert;
GO
DECLARE @ED varbinary(max)
SELECT @ED=encryptbykey(key_guid('SCSSOKey'), 'WeAreEncryptingThisText' )
PRINT @ED
SELECT @ED
SELECT CONVERT(VARCHAR, DecryptByKey(@ED))
GO
CLOSE SYMMETRIC KEY [SCSSOKey];
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment