Post reply

How can i do a query that shows the store procedures that have been encrypted?

  • January 17, 2005 at 2:07 pm

    #60911

    Friends is there someone? that knows how to do a query that shows the store procedures from BD that are encrypted.. i dont find any parameters from the table Sysobject that shows if the procedure has been encrypted.

     

    sorry my bad english i try to do better..

    Thanks.....................

  • January 17, 2005 at 2:15 pm

    #537729

    If the text in syscomments isn't readable, then it's encrypted.

  • January 17, 2005 at 2:16 pm

    #537730

    SELECT TOP 100 PERCENT dbo.sysobjects.name, dbo.sysobjects.xtype

    FROM dbo.sysobjects INNER JOIN

    dbo.syscomments ON dbo.sysobjects.id = dbo.syscomments.id

    WHERE (dbo.syscomments.encrypted = 1)

    ORDER BY dbo.sysobjects.xtype, dbo.sysobjects.name

  • January 17, 2005 at 2:38 pm

    #537735

    I find the solution In the syscomments exists a file called encrypted, thanks

  • January 17, 2005 at 2:50 pm

    #537740

    Thanks my friend in deep

  • January 17, 2005 at 9:49 pm

    #537769

    for info...There is a decryption utility you can use if you can to view the original source. dSQLSRVD- SQL Server SysComments Decryptor 1.1 by dOMNAR.

    Looks like it will not be untill SQL 2005 until the encryption will be truelly secure.

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

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