January 30, 2012 at 9:53 pm
how to configure Encryption for particular column in sql server 2008..?pls give me the step..?
January 31, 2012 at 12:00 am
Coolroof (1/30/2012)
how to configure Encryption for particular column in sql server 2008..?pls give me the step..?
How to: Encrypt a Column of Data
First google result for sql server encrypt column.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 31, 2012 at 4:00 am
😀
This is a how-to guide which will aims to help ms sql server developers and ms sql server administrators to implement Microsoft SQL Server 2005 Encryption methodologies.
This tutorial is a step-by-step guide for encryption and decryption in MS SQL Server 2005 and later (MS SQL2008 aka Katmai)
Creating Master Key
Before using encryption algoritms in SQL Server 2005 and SQL Server 2008, a master key should be created in the database where encryption is going to be used.
Note that master key is created seperately for each database on a SQL Server database instance
Before creating a master key, sql developers or sql server database administers that has the required permissions can run the below t-sql select query to see if a master key is created before.
SELECT * FROM sys.symmetric_keys
If there has been created a master key, you will see a result that is similar to below if you are running the t-sql select from sys.symmetric_keys view in MS SQL Server 2005,
From Article
http://www.kodyaz.com/articles/sql-server-2005-database-encryption-step-by-step.aspx
January 31, 2012 at 4:03 am
Koen Verbeeck (1/31/2012)
Coolroof (1/30/2012)
how to configure Encryption for particular column in sql server 2008..?pls give me the step..?How to: Encrypt a Column of Data
First google result for sql server encrypt column.
I'd have used LMGTFY 🙂
January 31, 2012 at 5:00 am
MysteryJimbo (1/31/2012)
Koen Verbeeck (1/31/2012)
Coolroof (1/30/2012)
how to configure Encryption for particular column in sql server 2008..?pls give me the step..?How to: Encrypt a Column of Data
First google result for sql server encrypt column.
I'd have used LMGTFY 🙂
I know, but somehow people don't really appreciate that 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply