Contents 

Ubitsoft SQL Enlight Online Help

Ubitsoft SQL Enlight

Managing Settings

Statement History Settings

Use the Statement History settings to configure:

Collect history of executed statements Enable or disable statements history
Statement history maximum size The maximum number of statements which to be stored.
Statement text maximum length The maximum allowed size of the statement text in order it to be saved in the history.

Location of the file storing the Statement History can be changed and file moved to different drive than the default. The default location is in the user's application folder. For example:

Windows XP/2003

C:\Documents and Settings\{username}\Application Data\Ubitsoft\SQL Enlight\1.8\

Windows Vista/7/2008

C:\Users\{username}\AppData\Roaming\Ubitsoft\SQL Enlight\1.8\

General Analysis Settings

Analysis Templates Import /Export

Export and import analysis templates in xml file and configure the source of the Analysis Context which to be used in Analysis Rule Designer.

Test Analysis Context

The Test Analysis Context setting specifies the location of the default analysis context xml file which to be used for Analysis Rule testing inside the Analysis Rule Designer.

Analysis Context Mode

Choose the detail level of the analysis context:

Basic

Basic mode will load only the most commonly used schema informaiton such as:

  • Server Information
  • Principals, Role Members
  • Schemas
  • Data Types
  • Assemblies
  • Tables, Views, Triggers
  • Functions, Partition Functions, Stored Procedures
  • Rules,Defaults,Synonyms
  • Xml Schema Collections
  • Indexes,Foreign Keys, Primary Keys, Check Constraints, Default Constraints
  • FullText Catalogs, Data Spaces, File Groups
  • Dependencies, Partition Schemes
  • Statistics
Full

The Full mode will load all the basic schema information and also some additional database objects:

  • Message Types
  • Service Contracts, Service Queues, Services, Service Bindings
  • Routes
  • SymmetricKeys
  • AsymmetricKeys, Certificates
  • Extended Properties, Event Notifications

SSMS Analysis Settings

This settings tab contains SQL Server Management Studio specific integration related configuration options.

Analysis before Parse and Execute commands

Enabling analysis before one of the two commands will make SQL Enlight run analysis before the specific command. If errors are found before the Execute command, the user will be prompted whether to continue execution of the script or not.

Two options for analysis rules are available:

  • Choose any of the existing analysis rules as a default for this command or use all active analysis
  • Be prompted to select rules just before running the analysis

Disable connection context

Enable or disable loading of the connection context when analyzing statements in the active code window.


When connection context is disabled, SQL Enlight does not attempt to load database context information and works without it. This setting will affect any context analysis rules and any rules which use the context information, but might speed up analysis in case only T-SQL script is analyzed or in case the database connection is not currently available.

The recommended setting for this option is not checked ( the connection context is enabled).

Disable connection context background loading

Enable or disable background loading of the active window connection context. To speed up connection context loading during analysis, SQL Enlight loads context information when the current window connection context is changed or new query document is opened.

This setting may be used to disable this behavior and this way to make SQL Enlight load database context information just before the running analysis. Disabling background loading may slow down the first time a database is analyzed, but can reduce the used by SQL Enlight memory.

The recommended setting for this option is not checked ( the connection context background loading is enabled).

Disable context in memory caching

Enable or disable database and server context information in memory caching. The setting can be used to reduce memory consumed by cached databases, but it can also slow down context loading when running analysis. Disabling memory caching will make SQL Enlight always load analysis context before analysis and release it after the analysis are complete.

The recommended setting for this option is not checked ( the memory caching is enabled).

Disk cache location

The setting specifies the location of the disk folder where database and server context information is stored. The disk cache is always enabled and is meant to speed up the loading of database context information.

The location can be changed in order to provide more or free disk space.

The default folder is user's application folder:

Windows XP/2003

C:\Documents and Settings\{username}\Application Data\Ubitsoft\SQL Enlight\1.8\Cache\

Windows Vista/7/2008

C:\Users\{username}\AppData\Roaming\Ubitsoft\SQL Enlight\1.8\Cache\

Layout Settings

See more about layout template settings in Managing Layout Templates topic.