Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-29 : 09:33:04
|
| Vijay writes "Hello SQL Team, I am into Support of a product which has SQL server 7.0 as the database server. I receive stored procedure in the encrypted form and i don't know how to view the Stored procedure to make changes according to the requirements which i have to work on.Please let me Know how to decrypt the stored procedure which is in encrypted form and after adding some lines again it should be encrypted.Awaiting your reply..Thanks in advanceVijay" |
|
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
Posted - 2002-03-29 : 09:42:38
|
quote:
Vijay writes "Hello SQL Team, I am into Support of a product which has SQL server 7.0 as the database server. I receive stored procedure in the encrypted form and i don't know how to view the Stored procedure to make changes according to the requirements which i have to work on.Please let me Know how to decrypt the stored procedure which is in encrypted form and after adding some lines again it should be encrypted.Awaiting your reply..Thanks in advanceVijay"
There is a free program I found to do this. E-mail me at SQLServerDBA@consultant.com and I'll give you the name. (I dont really want everyone in the world to be able to find it...  )DanielSQL Server DBA |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-03-29 : 18:27:16
|
| If you are supporting the product, then why don't you have access to non-encrypted source code? Surely your system has SOME form of source code storage outside of SQL Server, like storing sproc creation scripts in VSS, don't you? If not, I suggest you begin implementing that immediately.------------------------GENERAL-ly speaking... |
|
|
|
|
|
|
Encrypted Stored Procedure