4
votes
1answer
87 views

How to restore symmetric key on the new database?

I have an issue with symmetric key restoring on the another database. I have table in the first(old) database with encrypted column.(The table contains encrypted data) The key in the old database has ...
1
vote
1answer
87 views

Using EncryptByPassPhrase in where condition

I am using EncryptByPassPhrase of sql server. But i am not able to use where condition properly. DECLARE @login_details TABLE(uid integer,username varchar(10),password varbinary(100)) insert into ...
0
votes
1answer
812 views

How to grant permission for creating,reading and executing symmetric key in sql server 2008

We have user associated to a schema with limited privileges.During run time we are generating symmetric key using same user log-in.since the user has limited privilege, we are not able to create key ...
1
vote
1answer
200 views

One call to `decryptbypassphrase` for decrypting all columns

If I use ENCRYPTBYPASSPHRASE to encrypt the full table then how can I decrypt full table easily by using DECRYPTBYPASSPHRASE? Actually I have to use DECRYPTBYPASSPHRASE ('passphrase', column_name) ...
0
votes
2answers
112 views

Changing passphrase for EncryptByPassPhrase

I am using EncryptByPassPhrase to encrypting some columns. If I want to change the passphrase in the future, how can I change it?
1
vote
0answers
214 views

Full Text Search with Encryption SQL Vs NoSQL? [closed]

Can any tell Which will be better for online and offline projects
4
votes
1answer
195 views

DB Master Key Encrypted By *Correct* Service Master Key?

My client has frequently run process where we move databases from a prod environment to lower environments (refresh QA with prod database, etc). These DBs have database master keys on them. We have ...