after I have encrypted a stor proc, how can I know the definition of it? I only want to prevent others to know the definition, but sometimes I've to refer to the definition myself, how can I decrypt it if I have totally forgotten the definition? Thanks... Please visit my WebCam!!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
decrypt a stor proc
- Thread starter hmcheung
- Start date
According to BOL,
"Once encrypted, the definition of the stored procedure cannot be decrypted and cannot be viewed by anyone, including the owner of the stored procedure or the system administrator."
So you should make sure to store the source code in a secure location somewhere.
"Once encrypted, the definition of the stored procedure cannot be decrypted and cannot be viewed by anyone, including the owner of the stored procedure or the system administrator."
So you should make sure to store the source code in a secure location somewhere.
- Status
Similar threads
- Locked
- Question