I create my store procedure with encryption.
I am using MS sql 2005 / 2008
but how to generate it to a file (script file / *.sql)
because i want to deliver this script to my client.
Short answer is you don't. You will have to go to your code repository (VSS, ClearCase, what have you) to extract them. MS provides no way of recovering encrypted stored procedure code. Well, maybe they do if you open a case with them, and say "pretty please", but I doubt it.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.