INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS
Come Join Us!
Are you a
Computer / IT professional?
Join Tek-Tips now!
- Talk With Other Members
- Be Notified Of Responses
To Your Posts
- Keyword Search
- One-Click Access To Your
- Automated Signatures
On Your Posts
- Best Of All, It's Free!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.
Partner With Us!
"Best Of Breed" Forums Add Stickiness To Your Site
(Download This Button Today!)
"...I have found your site brilliant. What makes it good are the people that contribute to the site..."
Where in the world do Tek-Tips members come from?
Sample SQL 2005 Encryption Code
Posted: 6 Jul 05
This is based off of the CTP edition of SQL 2005.
This sample code will create a encryption key, open the key, and use the key to encrypt some data, then decrypt the data, then close the key.
OPEN SYMMETRIC KEY PrivateData DECRYPTION BY PASSWORD ='Password'
CREATE TABLE UserData
DECLARE @Key_GUID UNIQUEIDENTIFIER
SELECT @Key_GUID = Key_GUID
WHERE Name = 'PrivateData'
INSERT INTO UserData
(EncryptByKey(@Key_Guid, 'RawData', 1))
SELECT CONVERT(VARCHAR(20), DecryptByKey(UserData.Data, 1)) AS Data
DROP TABLE UserData
CLOSE SYMMETRIC KEY PrivateData
Back to Microsoft SQL Server: Setup and Administration FAQ Index
Back to Microsoft SQL Server: Setup and Administration Forum
Join Tek-Tips® Today!
Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.
Here's Why Members Love Tek-Tips Forums:
- Talk To Other Members
- Notification Of Responses To Questions
- Favorite Forums One Click Access
- Keyword Search Of All Posts, And More...
Register now while it's still free!
Already a member? Close this window and log in.
Join Us Close