encryption dilema....

[DLu]

I want to encrypt stored proc, trigger, role and view. And SQL could do it.

But I want to access it with some password when I need to see its content.
Any one knows SQL 2k has some similiar pwd to let you access the encrypted objects?

thanks
-D

[MAK]

why cant you use VSS or PVCS. and when implenting always encrpyt it.

[rmiao]

There is shareware utility to access encrypted objects.

[DLu]

MAK and Rmiao:
thanks for the info.
I have around 1000 databases and frequently need to implement application service patch (sp, trigger, view, rule...) across 40-50 servers. The service patch implementation may take 1 day(no more than 2 days) to finish.
Thus, direct access to encrypted objects for debuging and checking the individual database sql object version is neccessary.

Which shareware software could do this?

David

[MAK]

1. For such a number of servers and databases, why you need to have additional over head of encrypting and decrypting?

2. For such a infrastructure, you will be having change management process which in turn should have atleast VSS or PVCS. So why not use the existing VSS/PVCS you have.

3. Check with your company's standard and policy before doing this

[rmiao]

It calls dSQLSRVD.