[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.sqlserver.programming

Encrypted SP's

unknown

3/8/2007 9:25:00 PM

not sure how this happened but it happened on SQL Server 2000 before we
upgraded to 2005 with SP2, but now 3 of our stored procedures have a lock on
their icon and are marked as encrypted... how can I recover these? I need to
edit them and cant because of that! Thanks!


2 Answers

Tibor Karaszi

3/9/2007 9:45:00 AM

0

What result do you get from:

EXEC sp_helptext 'procname'

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/d...
http://www.solidqualitylea...


"Smokey Grindel" <nospam@nospam.com> wrote in message news:el8E6gcYHHA.3928@TK2MSFTNGP03.phx.gbl...
> not sure how this happened but it happened on SQL Server 2000 before we upgraded to 2005 with SP2,
> but now 3 of our stored procedures have a lock on their icon and are marked as encrypted... how
> can I recover these? I need to edit them and cant because of that! Thanks!
>


EMartinez

3/9/2007 1:15:00 PM

0

On Mar 9, 3:44 am, "Tibor Karaszi"
<tibor_please.no.email_kara...@hotmail.nomail.com> wrote:
> What result do you get from:
>
> EXEC sp_helptext 'procname'
>
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://www.solidqualitylea...
>
> "Smokey Grindel" <nos...@nospam.com> wrote in messagenews:el8E6gcYHHA.3928@TK2MSFTNGP03.phx.gbl...
> > not sure how this happened but it happened on SQL Server 2000 before we upgraded to 2005 with SP2,
> > but now 3 of our stored procedures have a lock on their icon and are marked as encrypted... how
> > can I recover these? I need to edit them and cant because of that! Thanks!

Encryption is not typical when doing this kind of upgrade. If the
stored procedures were encrypted via the 'with encrytion' keywords,
I'm afraid there is no way to access them (even w/sp_helptext); unless
there is a third party decryption utility available for 128 bit or
higher encryption. Do you have a backup somewhere that can be used on
another machine that still has SQL Server 2000 installed that can
script the 3 stored procedures?

Regards,

Enrique Martinez
Sr. SQL Server Developer