AquaFold
HOME SCREENSHOTS DOWNLOAD DOCUMENTATION SUPPORT LICENSING CONTACT
 

Documentation: Aqua Data Studio 6.5 - New Features     HTML Documentation download, ZIP: ads-docs.zip (Size: 84.7MB) / ads-docs-no-shots.zip (Size: 1.2MB)
  Getting Started
  Installation
  JDBC Drivers
   Oracle 8i
   Oracle 9i
   Oracle 10g
   DB2 7.2
   DB2 8.1
   DB2 9.0
   SQL Server
   Sybase ASE
   Sybase Anywhere
   Sybase IQ
   Informix
   PostgreSQL
   MySQL
  Memory Configuration
  Character sets
  Registering Servers
   MSDE 2000
   SQL Express 2005
   PostgreSQL SSL
  Application
   Application Menus
   Application Toolbar
   Browser and Scripting
   Visual Editing
   SQL History and Archive
   Shortcut Toolbar
   Key Mappings
   Key Mapping Assistant
   Custom Keymap Profiles
   Options
   Settings
   New Frame Window
   Details View
   Command Line
  Query Window
   Basics
   Toolbar
   Server Side Comments
   SQL Automation
   Aqua Commands
   Morph to Delimited List
   Results
   Save Results
   Auto-completion
   Popup Menu
   SQL Formatter
   Permissions
   Parameterized
   Pivot Results (Grid and Chart)
   Grid Results (Grid and Chart)
  Editors
   SQL Editor
   Text Editor
   HTML Editor
   XML Editor
   Regular Expressions
  Image Viewer
  Visual Explain Plan
   Basics
   Explain Plan
   Explain Diagram
   Whiteboard
  Procedure/Package Editor
  SQL Debugger
   Sybase Debugger
   Oracle Debugger
  Tools
   Table Data Editor
   Schema Script Generator
   Server Script Generator
   ER Diagram
   Query Builder
   Import Tool
   Export Tool
   Execution Monitor
   Object Search
  Compare Tools
   Schema Compare
   Tab Compare
   Directory Compare
   File Compare
   Copy History Compare
   Results Compare
  Oracle DBA Tools
   Instance Manager
   Storage Manager
   Rollback Manager
   Log Manager
   Security Manager
   Session Manager
   SGA Manager
   Server Statistics
  SQL Server DBA Tools
   Instance Manager
   Storage Manager
   Security Manager
   Session Manager
   SQL Agent Manager
  Sybase DBA Tools
   Instance Manager
   Storage Manager
   Security Manager
   Session Manager
  Source Control
   Subversion
   CVS
MS SQL DBA Tools - Instance Manager

Provides manageability for the MS SQL instance allowing a user to view and modify server parameters and to view server version information and the server logs.
MS SQL DBA Tools - Instance Manager


Toolbar Operations -

Refresh : Will refresh all tabs in the instance manager from the database
Find: Find tool to search the grid of the current tab
Find Next: Find the next instance of the previous find
Edit Parameter: Edit the value of the currently selected parameter
Archive: Select a server log archive to be displayed

Summary Tab - Provides a summary of the MS SQL instance

DBMS_NAME: Name of the DBMS
DBMS_VER: Version of the DBMS
OWNER_TERM: Adaptive Server's term for a table owner (the second part of a three-part name)
TABLE_TERM: Adaptive Server's term for a table (the third part of a three-part name)
MAX_OWNER_NAME_LENGTH: Maximum length of the name for a table owner (the second part of a three-part name)
TABLE_LENGTH: The maximum number of characters for a table name
MAX_QUAL_LENGTH: Maximum length of the name for a table qualifier (the first part of a three-part table name)
COLUMN_LENGTH: The maximum number of characters for a column name
IDENTIFIER_CASE: The case sensitivity of user-defined names (table names, column names, and stored procedure names) in the database
        (the case in which these objects are presented in the system catalogs)
TX_ISOLATION: The initial transaction isolation level the server assumes, corresponding to an isolation level defined in SQL92
COLLATION_SEQ: The assumed ordering of the character set for this server
SAVEPOINT_SUPPORT: Does the underlying DBMS support named savepoints?
MULTI_RESULT_SETS: Does the underlying DBMS or the gateway itself support multiple results sets (can multiple statements be sent through
        the gateway, with multiple results sets returned to the client)?
ACCESSIBLE_TABLES: In sp_tables, does the gateway return only tables, views, and so on, that are accessible by the current user
        (that is, the user who has at least select privileges for the table)?
USERID_LENGTH: The maximum number of characters for a user name
QUALIFIER_TERM: Adaptive Server's term for a table qualifier (the first part of a three-part name)
NAMED_TRANSACTIONS: Does the underlying DBMS support named transactions?
SPROC_AS_LANGUAGE: Can stored procedures be executed as language events?
ACCESSIBLE_SPROC: In sp_stored_procedures, does the gateway return only stored procedures that are executable by the current user?
MAX_INDEX_COLS: Maximum number of columns in an index for the DBMS
RENAME_TABLE: Can tables be renamed?
RENAME_COLUMN: Can columns be renamed?
DROP_COLUMN: Can columns be dropped?
INCREASE_COLUMN_LENGTH: Can column size be increased?
DDL_IN_TRANSACTION: Can DDL statements appear in transactions?
DESCENDING_INDEXES: Are descending indexes supported?
SP_RENAME: Can a stored procedure be renamed?
REMOTE_SPROC: Can stored procedures be executed through the remote stored procedure APIs in DB-Library?
SYS_SPROC_VERSION: The version of the catalog stored procedures currently implemented



MS SQL Instance Manager Summary
MS SQL DBA Tools - Instance Manager - Summary Tab
Parameters Tab - MS SQL instance parameters

Parameter: Name of the parameter
Value: Value of the parameter
Run: Current value
Min: Minimum value of the parameter
Max: Maximum value of the parameter
Dynamic: Indicates whether the parameter can be changed during a session (dynamic), can be changed on the server restart (static) or not changeable (read-only)

MS SQL Instance Parameters
MS SQL DBA Tools - Instance Manager -Instance Parameters Tab
Server Logs Tab - MS SQL instance server logs

Message: Server log entity

MS SQL Server Logs
MS SQL DBA Tools - Instance Manager - Server Logs Tab
Home Screenshots Downloads Documentation Support Licensing Contact Copyright© 2001-2007 AquaFold, Inc. All Rights Reserved