I right click on the venc or vdec procedures, execute the procedure and give the input data.

DECLARE@ret_value int,

@out_data varchar(200)

EXEC @ret_val = [dbo].[vdec]

@in_data1 = N'0x008b16f1b5e3ea4eaba24e2348cbf9c501000000fc5b0d5c0',

@in_data2 = N'e2f06f21ff1468953fe1047f3002e61eb0c4cb0e08bdf1ef56b',

@in_data3 = N'80d19af6eecaa4db53e145db9bef3854becd28fb20a857bb6e87',

@in_add_auth =...

I think my previous thread is very well confusing.

I would like to know if it is possible to create like a script to execute the vdec(decrytion procedure)...

Thanks for all your help. I appreciate it.

Alzdba, Thanks for your response.

Here is the output:

select MKP.*

, D.name as DbName

from sys.master_key_passwords MKP

inner join sys.credentials C

on MKP.credential_id = C.credential_id

inner join sys.database_recovery_status DRS

on MKP.family_guid = DRS.family_guid

inner join sys.databases D

on DRS.database_id...

Steve,

Thanks for the reply. Below is what I did on the Prod db:

1. Created Master Key encryption by password.

2. Create Certificates

3. Create Symmetric keys encryption by...

Any ideas/suggestions, please?

It is very strange that the decrypt is not working after restoring the same master key and bouncing the db. I would think this is a very basic...

Yes, we are able to encrypt & decrypt new data without any issue. Just the existing encrypted values we are unable to decrypt and it returns NULL.

I just tried backup...

Steve,

This is the database master key I ran on the Prod db in March and after the test db restore last week I'm running the same master key on...

Steve,

I'm talking about the key below..

IF NOT EXISTS

(SELECT * FROM sys.symmetric_keys WHERE symmetric_key_id = 101)

CREATE MASTER KEY ENCRYPTION BY

...

Thanks for the info.

I created the same Master key in test db that I used for the Prod db in March. I bounced the test db after recreating...

Sorry, I have another doubt. Is it required to rebuild the views after the SP3 install??

We are having some issues on a few programs that runs a view....

haha, Lol

Thanks Gail.

I've installed SP3 for SQL server and now when i run SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition') I get Productlevel as SP3.

Are there any specific differences/enhancements/updates from RTM ->...

Thanks everyone. I tried the option 1 and it worked for me. Thanks again.

Yes, the application re-creates the procedure.. and it connects as the user's login there is no seperate application login..

Thanks