Chat now with support
Chat mit Support

Toad for SQL Server 8.0 - Installation Guide

SQL Server Options

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

  1. Select Tools | Options |Database |SQL Server.

  2. 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:

    • GO

    • Semicolon

    • Blank line

    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.

 

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen