Enable quoted_identifier: Causes connection to follow the SQL-92 rules regarding quotation mark delimiting identifiers and literal strings.Enable db filters for query window: enables/disables db filters for query windows using this connection.Charset: Character set used for the connection.Always display column name in results: enables/disables displaying column names in results.TRANSACTION_SERIALIZABLE - A constant indicating that dirty reads, non-repeatable reads and phantom reads are prevented. TRANSACTION_REPEATABLE_READ - A constant indicating that dirty reads and non-repeatable reads are prevented phantom reads can occur. TRANSACTION_READ_UNCOMMITTED - A constant indicating that dirty reads, non-repeatable reads and phantom reads can occur. TRANSACTION_READ_COMMITTED - A constant indicating that dirty reads are prevented non-repeatable reads and phantom reads can occur. TRANSACTION_NONE - A constant indicating that transactions are not supported. Txn Isolation Level: Support for setting Transaction Isolation Level.With options in Advanced properties of a Server, you can :Įnable Database Filters in Query Analyzer. Go to the Advanced Tab and make changes in the Options. Right Click on the Server - A Popup Menu Appears. Tip : Using the dropdown at the top of the Filter Tab, quickly change your Schema or Folder View.Įdit the Server Properties to use Advanced Properties in Aqua Data Studio: Use options to INCLUDE or EXCLUDE all Schemas and Folders.Įnter the Schema or Folder name in the specified text area and Press OK.
Sometimes you would like to view only specific Schemas. Default Folders are Tables, System Tables, Views, Indexes, Triggers, Procedures, Functions. You can Create, Edit or Delete Object Folders. Exclude Objects: A list of objects to exclude after the main filter is applied.Include Objects: A list of objects to include after the main filter is applied.Filter Objects: Allows the user to specify the main schema browser filter for object types, on whether to include or exlude all.Exclude Databases/Schemas: A list of databases/schemas to exclude after the main filter is applied.
0 kommentar(er)
