Honestly I was just going through that article.

when I tried following query

USE master

GO

SELECT * FROM sys.symmetric_keys WHERE name LIKE '%'

GO

i found following two results

##MS_DatabaseMasterKey##--keylength-128--algorithm is --D3

##MS_ServiceMasterKey##--keylength-128--algorithm is --D3

I have no idea who made this.

But when I tried to follow your suggested article..I found error on first step..that "THERE IS ALREADY A MASTER KEY IN THE DATABASE"

When I run the following query

use master

SELECT * FROM sys.certificates

it gives me certificate which I made few day back called "TDECert" it is also states that ENCRYPTED_BY_MASTER_KEY in othe coulmn.

I am now confused..what to do now.

Please inform me..is there any way I can clear all out and start from begining.

I know I am bigginer and doing hard task like encryption by refering books, internet, asking friends like you and putting some own logic, I might have stupid quetions..but please help me to improve.

thanks.