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!

how to generate script store procedure (encrypted).

Status
Not open for further replies.

PlutoDev

Programmer
Sep 21, 2002
25
ID
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.

thank's
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top