Post reply

How to Encrypt or Decrypt .....

  • July 16, 2003 at 2:30 am

    #59075

    How to Encrypt or Decrypt Stored Procedure, Trigers or functions.

    Thanks in advance.

    Sachin

    Sachin Bhaygude


    Sachin Bhaygude

  • July 16, 2003 at 2:56 am

    #465637

    hi,

    try (from BOL)

    create procedure {proc_name}... with encryption.

    create trigger {trig_name} on {object_name}

    with encryption

    Paul

  • July 16, 2003 at 4:17 am

    #465646

    Just make sure that you keep a copy of your decrypted code as it is more of a pain to lose and retrieve. Yes it can be decrypted and really quite easy so don't expect it to be a great measure of security just a bit of a deterent.

  • July 16, 2003 at 4:23 am

    #465648

    we had some encrypted procedures in a production system for a while. However when it came to troubleshooting it became a pain, as we couldn't be 100% sure of the version in production. so all new procedures going to the system are now unencrypted.

  • July 16, 2003 at 7:47 am

    #465666

    Look for dSQLSRVD using Google. If you have sysadmin rights to the machine, you can decrypt the stored procedures, triggers, and functions.

    K. Brian Kelley

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

    K. Brian Kelley
    @kbriankelley

Viewing 5 posts - 1 through 4 (of 4 total)

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