Determine if DB is encrypted

• jmonty

  SSC-Addicted

  Points: 407

  More actions

  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?

   

   

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  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.

   

   

• UconnDBA

  Default port

  Points: 1439

  More actions

  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

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  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