This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.
To set SQL Server options
Select Tools | Options |Database |SQL Server.
Review the following for additional information:
Show system objects |
Select this checkbox to display or hide system tables and objects. Default: Cleared |
Show schema in separate column |
Select this checkbox to display the object owner in the objects list of the Object Explorer. Note: As index owner is a table but not a schema, when the option is selected, table name is removed from the index title and moved to the separate column. Default: Cleared |
Run script on new connection |
Select this checkbox to run a SQL script each time you create a new connection. The default InitialSqlServer.sql file contains the following statements: SET ARITHABORT ON SET CONCAT_NULL_YIELDS_NULL ON SET ANSI_NULLS ON SET ANSI_NULL_DFLT_ON ON SET ANSI_PADDING ON SET ANSI_WARNINGS ON SET QUOTED_IDENTIFIER ON SET ROWCOUNT 0 SET IMPLICIT_TRANSACTIONS ON Caution: To avoid conflicts during upgrades, Quest strongly recommends that you do not modify the default script. Instead, save the script to a new file or different directory before modifying it. Default: Selected |
Batch separator |
Enter a batch delimiter using one of the following formats:
Default: GO |
Enable database backup checking |
Verify whether a database has been backed up. If selected, an icon indicator and tooltip of the databases' status displays in the Database Explorer or Object Explorer. Default: Cleared |
Change status if not backed up for |
Enter the number of days and hours that can elapse before an indicator displays that the database needs to be backed up. Default: 1 day, 0 hours |
Tips:
To navigate to the directory where option settings are stored, click the Application Data Directory link in the About dialog (Help | About).
To search for a partial or complete option name or value, use the Search field at the bottom of each Options page. See About Options for more information.
© ALL RIGHTS RESERVED. Feedback 利用規約 プライバシー Cookie Preference Center