[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

How to decrypt encrypted MS SQL Server store procedure?

Posted on 2004-10-30
2
Medium Priority
?
296 Views
Last Modified: 2008-01-09
I have a problem to exports the stored procedure from the source database to destination database, the problem is due to the encrypted store procedure, show how do i decrypt this store procedure.

0
Comment
Question by:dynamicrevolutions
2 Comments
 
LVL 15

Accepted Solution

by:
mcmonap earned 1000 total points
ID: 12451133
Hi dynamicrevolutions,

As far as I am aware it is not possible to dycrypt encrypted stored procedures, you need to have the source code from the sp elsewhere in order to recreate them.

CREATE PROCEDURE details from BOL:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_create_4hk5.asp

There are utilities available but I haven't used them so don't know what they are like:
http://www.securiteam.com/tools/6J00S003GU.html
0
 
LVL 6

Assisted Solution

by:Duane Lawrence
Duane Lawrence earned 1000 total points
ID: 12451143
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ready to get certified? Check out some courses that help you prepare for third-party exams.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.
Suggested Courses

590 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question