THANKS

got it...working on it...but let me know if you have any other article..

Thanks.

My requirements are little different.

I want to send to each individual their own record. Let's say how much sales he did on that day!

actually I have table like as follows

SID Name Grade email

101 Peter 87...

Thanks for your help.

i got almost 90% but need a help to finish it...

here is what I got,

use AdventureWorks2012

CREATE TABLE tbl

([MemberCode] int, [ClaimID] int, [StartDate] date, [EndDate] date, [CaseDate] date);

INSERT INTO tbl

([MemberCode], [ClaimID],...

Thanks

Please find following attachment , specially for Steve, Sean and Lowell...

Thank Lowell!

Is it possible to restore the certifacate and symmetric key from backup location into the database's security folder into SQL SERVER 2008 R2?

thanks.

Hi Lowell,

I created one database called encrypt_test1, in that I created one table called Customer_data.

I encrypted single column, called "AccountNumber" in table called Customer_data.

Now I want to restrict other users...

This time I gave attetion while creating database, and choose my user name as owner of this database.

but still , the server on which we are working is sqlserver/server2008r2

under which...

when I tried..following one..

use encrypt_test1

DENY SELECT ON Object::dbo.Customer_data to [sqlserver\ackj]

it says that

Command(s) completed successfully.

but, when I run the following from my co-worker station whose user name is [sqlserver\ackj]

USE encrypt_test1;

GO

OPEN SYMMETRIC...

I tried this one..

deny VIEW DEFINITION ON SYMMETRIC KEY::SymmetricKey1 TO [sqlserver\ackj];

deny VIEW DEFINITION ON Certificate::Certificate1 TO [sqlserver\ackj];

GO

but it didn't help.

still [sqlserver\ackj] user can see the data with above command.

Sean Lange (7/23/2013)

---

Learner44 (7/23/2013)

---

You are 101% right..Sean

but, things here are ongoing..with millions of data across the 40+ tabels..

and account number is used as reference in almost 32+ tables.

Due to recent...

Thanks Sean and Steve.