Post reply

Determine if DB is encrypted

  • August 13, 2004 at 11:43 am

    #83473

    Newbie question:

    I haven't worked much with encryption.

    How can I determine which (if any) of my SQL DBs are encrypted?

     

     

  • August 13, 2004 at 11:57 am

    #518936

    Database can't be encrypted.

    SQL Server encrypts :

    • Login and application role passwords stored in SQL Server.
    • Any data sent between the client and the server as network packets.
    • Stored procedure definitions.
    • User-defined function definitions.
    • View definitions.
    • Trigger definitions.
    • Default definitions.
    • Rule definitions.

     

     

  • June 13, 2012 at 5:50 am

    #1500281

    In SQL 2008 and above a database can be encrypted. You can query the is_encrypted column in sys.databases to determine whether TDE is enabled for a particular database.

    for more info on TDE (Transparent data encryption) go to http://msdn.microsoft.com/en-us/library/bb934049.aspx

    John

  • June 13, 2012 at 5:54 am

    #1500283

    Please note: 8 year old thread that dates back from before SQL 2008 exited.

    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

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

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