Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQLS2K: How to encrypt and decrypt objects Expand / Collapse
Author
Message
Posted Tuesday, April 15, 2008 10:58 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 6, 2014 10:29 AM
Points: 186, Visits: 811
Hello,

I've got three questions that i'll appreciate if you can answer me as quickly as possible.
Theres a lot of sp that were encrypted by dba that its not working with us and anyone knows the code of this procedures.
I need to see the code of this procedures because the performance of the machine is completely horrible after 7 pm and cant delete them because i really don't know what they are doing.

- How can i see the code of encrypted stored procedures?
- Is there any tool that i can use to decrypt this objects?
- How can i create encrypted objects?

The code that appears is as follow:

drop procedure [owner].[procedure_name]
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
setuser N'[owner]'
GO
/****** Encrypted object is not transferable, and script can not be generated. ******/
GO
setuser
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

Thanks and regards
JMSM [Wink]
Post #485183
Posted Tuesday, April 15, 2008 11:40 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Thursday, July 24, 2014 4:49 PM
Points: 4,065, Visits: 5,277
See this thread for links to decryption tools: http://www.sqlservercentral.com/Forums/Topic396563-119-1.aspx.

See "Create Procedure" in BooksOnLine for syntax to create an encrypted stored procedure.


Greg
Post #485212
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse