SQLS2K: How to encrypt and decrypt objects

• JMSM

  SSCertifiable

  Points: 5440

  More actions

  April 15, 2008 at 10:58 am

  #181403

  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]

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  April 15, 2008 at 11:40 am

  #802725

  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