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.
-
The name of the encrypted object.
-
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.
-
The object's ID as known to the associated SQL Server.
-
The name of the schema that is associated with the encrypted 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.
-
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.
-
If the encrypted object is a view or table trigger then this field will be set to either Table or View.
-
The name of the database that the encrypted object resides in. For objects that are server-based, this field will be empty.
-
The database's ID as known to the associated SQL Server. For objects that are server-based, this field will be empty.
-
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.
-
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.
-
The user name used to log on to the SQL Server.
-
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.
-
The instance name, if any, of the SQL Server associated with the encrypted object.
-
The IP Address of the SQL Server associated with the encrypted object.
-
The custom alias given to the SQL Server associated with the encrypted object.
-
The full version number of the SQL Server associated with the encrypted object.
-
The friendly name of the SQL Server associated with the encrypted object, based on the Server Version.
-
The status of the SQL Server associated with the encrypted object. This field will either be Connected or Disconnected.