• I guess to call Microsoft Support , I might have to check with my boss, for my rights to do that.

    But Steve,

    I have another option..I don't know whether it will work out or not.

    Can I follow the same thing with "tempdb" system database.?

    Like use tempdb-> create master key-> create certificate-> uset that certificate to encrypt the personal database-

    than I will create one database in SqlServer called "student", I will enter few fake records.

    The reason why I am asking is, I am here for short time period on this job, I need to produce the report based on performance counter/measurment after encryption is done.

    for an example performance of encrypted database and non-encrypted database.

    and I know I am just more than bigginer in this encypting database.

    or I would like to follow your new idea if you have any!

    thanks.