Post reply

INSERT into sys.objects on 2008

  • November 10, 2011 at 8:44 am

    #1405838

    Dev @ +91 973 913 6683 (11/10/2011)

    GilaMonster (11/10/2011)

    Minnesota - Viking (11/10/2011)

    Any Ideas as to how to SCRIPT a encrypted VIEW or for that matter any object ?

    my Generate script task stops coz it cant script one of the views in DB which is Encrypted.

    RedGate SQLPrompt (professional) can script encrypted views.

    How it is possible? The encryption logic resides in SQL Server metadata & binaries. How can a third party tool get the decryption logic for the same?

  • November 10, 2011 at 8:45 am

    #1405839

    Dev @ +91 973 913 6683 (11/10/2011)

    GilaMonster (11/10/2011)

    Minnesota - Viking (11/10/2011)

    Any Ideas as to how to SCRIPT a encrypted VIEW or for that matter any object ?

    my Generate script task stops coz it cant script one of the views in DB which is Encrypted.

    RedGate SQLPrompt (professional) can script encrypted views.

    How it is possible? The encryption logic resides in SQL Server metadata & binaries. How can a third party tool get the decryption logic for the same?

    http://msdn.microsoft.com/en-us/library/ms187926.aspx

    ENCRYPTION

    Indicates that SQL Server will convert the original text of the CREATE PROCEDURE statement to an obfuscated format. The output of the obfuscation is not directly visible in any of the catalog views in SQL Server. Users who have no access to system tables or database files cannot retrieve the obfuscated text. However, the text will be available to privileged users who can either access system tables over the DAC port or directly access database files. Also, users who can attach a debugger to the server process can retrieve the decrypted procedure from memory at runtime. For more information about accessing system metadata, see Metadata Visibility Configuration.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 10, 2011 at 8:46 am

    #1405840

    Dev @ +91 973 913 6683 (11/10/2011)

    GilaMonster (11/10/2011)

    Minnesota - Viking (11/10/2011)

    Any Ideas as to how to SCRIPT a encrypted VIEW or for that matter any object ?

    my Generate script task stops coz it cant script one of the views in DB which is Encrypted.

    RedGate SQLPrompt (professional) can script encrypted views.

    How it is possible? The encryption logic resides in SQL Server metadata & binaries. How can a third party tool get the decryption logic for the same?

    p.s. The first part of becoming a master is learning to research.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 10, 2011 at 8:50 am

    #1405842

    @dev, here's something you might love if you used =>

    http://lmgtfy.com/?q=sql+server+decrypt

  • November 10, 2011 at 8:53 am

    #1405844

    p.s. The first part of becoming a master is learning to research.

    Got it. 🙂

Viewing 5 posts - 16 through 19 (of 19 total)

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