-- GENKEY.SQL sample script demonstrating xp_generatekey
--
-- Michael Coles, MCDBA
-- 7/2005
--
DECLARE @key VARCHAR(255)
EXEC master..xp_generatekey 128, @key OUTPUT
PRINT 'Your Key is: ' + @key

DECLARE @plaintext VARCHAR(255)
SET @plaintext = 'THIS ENCRYPTION WAS BROUGHT TO YOU COURTESY OF BLOWFISH'
PRINT 'Your plain text is: ' + @plaintext

DECLARE @encryptedtext VARCHAR(255)
DECLARE @decryptedtext VARCHAR(255)

EXEC master..xp_blowfishencrypt @plaintext, @key, @encryptedtext OUTPUT
PRINT 'Your encrypted text is: ' + @encryptedtext

EXEC master..xp_blowfishdecrypt @encryptedtext, @key, @decryptedtext OUTPUT
PRINT 'Your decrypted text is: ' + @decryptedtext