SQLS2K: How to encrypt and decrypt objects

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » SQLS2K: How to encrypt and decrypt objects

SQLS2K: How to encrypt and decrypt objects

Rate Topic

Display Mode

Topic Options

Author

Message

JMSM

Posted Tuesday, April 15, 2008 10:58 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 6:20 AM
Points: 185, Visits: 759

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

Greg Charles

Posted Tuesday, April 15, 2008 11:40 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 5:14 PM
Points: 4,009, Visits: 4,891

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 »

Permissions