Yes, This wxactly what I want..

But, Here is the thing, The first document which you have provided me, as you know I suceessfully understood it and appield it too.

No I...

Hi,

Thanks for those good articles. It solves my half purpose.

As there number of user for couple of tables , in which case we can not assign different roles to...

Hi,

I successfully applied/used symmetric key in order to encrypt the one particular column data.

it also show me that real number - > encrypted numbers -> decryted number(real number).

Now, again I...

perfact...

I have one table called Table_Update in my local server, which had three columns( Table_name, Start_date, End_date)

I have around 1500 tables on linked server, that has "Start Date" and "Last...

OK I have started looking on how to restore the database on different server..

if been through any article for this please let me know..

thanks.

I already metioned I am new to this encryption field..

I am following steps from the msdn articles..doing this and understaing them with all of your help.

GilaMonster (6/19/2013)

To prove it won't restore without the...

I am sorry if I didn't understand your quetion and not answered..

actually I was running the query to restore the database from TDEPost.bak file via sql sommand which I just...

I am not sure..I found this step similar and my goal oriented..so I followed them.

My objective is to show, that I have already encrypted database.

Now my senior needs to check,...

what is your objective?

Do you want to apply merge statement or what?

Please also guide me about how to go for overhead and performance counter before and after the encryption!!!

Please.

thanks.

Hi Steve,

So I included client statistics option just to check a kind of performance.

I exceuted different queries in different mode of encryption

[p]TRIAL=> ENCRPTN=> CLNTPRCESNGTIME=> TTLEXETIME=> QUERY_INCLUDES

...

Hi Steve..

M I doing the right thing to check the performance!!!

Please let me know how can I make it correct OR better!!

USE Student;

GO

ALTER DATABASE Student

SET ENCRYPTION...

Thanks Steve,

Just to confirm, Here the we can measure the performance by most likely large number of DML operations (running many insert, update and delete statments in a sequence) and...