Home Forums Testing Center SQL Server Security Skills How can I unencrypted a stored procedure RE: How can I unencrypted a stored procedure

  • November 26, 2007 at 11:31 am

    #754185

    Ron Aughenbaugh (11/26/2007)

    IF I am not mistaken I thought the unencrypted version is stored in one of the sys tables. Unfortunately I can't remeber which one.

    Unfortunately, no. In syscomments it is encrypted. I believe in SQL Server 2005 it's encrypted as well. SQL Server 2005 makes it more difficult because you've got to come in via DAC to be able to decrypt.

    K. Brian Kelley
    @kbriankelley