Help !!Decrypting Stored Procedures and Views 
Author Message
 Help !!Decrypting Stored Procedures and Views

Need to know if I can decrypt a stored procedures that has been encrypted in
the create stored procedure statement in SQL SERVER 7.0.

I've used the following syntax to create the stored procedure this example
can be used in the pubs database that came with SQL SERVER 7.0:

CREATE PROCEDURE au_info_all
WITH ENCRYPTION

AS

SELECT au_lname, au_fname, title, pub_name

    FROM authors a INNER JOIN titleauthor ta

        ON a.au_id = ta.au_id INNER JOIN titles t

        ON t.title_id = ta.title_id INNER JOIN publishers p

        ON t.pub_id = p.pub_id



Fri, 07 Sep 2001 03:00:00 GMT
 Help !!Decrypting Stored Procedures and Views

Do you think that would defeat the whole purpose of encrypting a SP.
Dropping it is your only option.

-GertD



Fri, 07 Sep 2001 03:00:00 GMT
 Help !!Decrypting Stored Procedures and Views
Joseph,

 The 6.5 algorithm was broken, so MS changed it for 7.0.  I'm sure it's only a
matter of time before someone breaks it though...

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 (Please post ALL replies to the newsgroup only unless indicated otherwise)
 For SQL FAQ entries see
 http://go.compuserve.com/sqlserver (library 1) - latest stuff is always here
 www.ntfaq.com/sql.html
 http://www.swynk.com/faq/sql/sqlserverfaq.asp



Fri, 07 Sep 2001 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. How to decrypt Stored Procedures, Views and Triggers in SQL Server 2000

2. this code decrypts encrypted Stored Procedures, Views and Triggers SQL Server 2K

3. Please help to convert view on views to stored procedure

4. Please help to convert view on views to stored procedure

5. Decrypt Store Procedure

6. How to decrypt a stored procedures in sql server 2000

7. How to decrypt a stored procedures in sql server 2000

8. Decrypt Store Procedure

9. Decrypt Stored Procedure

10. Decrypt Stored Procedure..

11. Decrypt Stored Procedure!

12. decrypt stored procedure?


 
Powered by phpBB® Forum Software