Decryptor Interface - Object Properties Window

Last Updated: 01.06.2019

---

The Object Properties Window displays detailed object and connection information for the encrypted object associated with the Decryption Window's active tab. Each time a tab is changed this window will be updated accordingly. The Object Properties Window is used only to display information and is not editable.

Object Data

• Name

  The name of the encrypted object.
  
  

• Type

  The encrypted object's type. This will be set to any of the possible encrypted object types that the SQL Server associated with the object understands.
  
  

• ID

  The object's ID as known to the associated SQL Server.
  
  

• Schema

  The name of the schema that is associated with the encrypted object.
  
  

• Parent Object

  If the encrypted object is a view or table trigger then this field will be populated with the view or table name the trigger is associated with.
  
  

• Parent ID

  If the encrypted object is a view or table trigger then this field will be populated with the id of the view or table the trigger is associated with.
  
  

• Parent Type

  If the encrypted object is a view or table trigger then this field will be set to either Table or View.

Database Details

• Name

  The name of the database that the encrypted object resides in. For objects that are server-based, this field will be empty.
  
  

• ID

  The database's ID as known to the associated SQL Server. For objects that are server-based, this field will be empty.
  
  

• Compatibility Level

  The compatibility level and product version of the database that the object resides in. SQL Server allows for databases to have different compatibility levels in order to support older versions internally. For objects that are server-based, this field will be empty.
  
  

• Family GUID

  The database's Family GUID as known to the associated SQL Server. This may be helpful when running problem scripts in SQL Server Management Studio. For objects that are server-based, this field will be empty.

Connection Details

• Login Name

  The user name used to log on to the SQL Server.
  
  

• Server Name

  The name of the SQL Server associated with the encrypted object. This will display exactly how it was entered in the Add SQL Server Dialog.
  
  

• Instance Name

  The instance name, if any, of the SQL Server associated with the encrypted object.
  
  

• IP Address

  The IP Address of the SQL Server associated with the encrypted object.
  
  

• Alias

  The custom alias given to the SQL Server associated with the encrypted object.
  
  

• Server Version

  The full version number of the SQL Server associated with the encrypted object.
  
  

• Product Version

  The friendly name of the SQL Server associated with the encrypted object, based on the Server Version.
  
  

• Status

  The status of the SQL Server associated with the encrypted object. This field will either be Connected or Disconnected.