May 31, 2007 at 9:44 am
Does anyone know how to either decrypt a stored procedure in 2005 or copy an encrypted procedure from one database to another? I tried writing an SSIS package to move the object, but had not luck. It reports success, but doesn't copy the object
May 31, 2007 at 9:57 am
There's a bunch of utilities that can do this for you. A google search for "decrypt stored procedure sql server" should yield results.
May 31, 2007 at 10:05 am
Right, but they all want you to pay, the free ones only seem ot have 2000 functionality, not 2005. Anyone know of a free solution?
May 31, 2007 at 10:38 am
Sorry haven't seen a free one. Bug your boss, he should spring for the utility. It's not that much.
June 1, 2007 at 3:52 am
In SQL 2000 it was possible to read the text from an encrypted stored procedure by opening a backup file in notepad. Someone told me thats still possible in 2005 but I haven't tested it.
Markus
[font="Verdana"]Markus Bohse[/font]
June 1, 2007 at 7:38 am
that did not work from me. I found a script online that got me most of the way there. It cut off the end, so I had to do some modifications, but I got it to work, it's not perfect as it puts some line breaks where they don't belong, but once you delete them, you have the unencrypted proc. I found the script here http://education.sqlfarms.com/education/ShowPost.aspx?PostID=784
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply