SQLS2K: How to encrypt and decrypt objects

  • 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]

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply