Query Editing

SQLDBcontrol has a host of other features designed to provide the best possible tools to to help manage your SQL Server™ environment.

Security

SQLDBcontrol is totally integrated with Microsoft® SQL Server™ security, eliminating the need to manage separate security accounts. You log on to SQLDBcontrol using your standard SQL Server™ login - regardless of whether your environment is using SQL Server™ security or Windows™ integrated security. Once you register a SQL Server™ within the application, you don't need to register again unless you wish to change your login details.

Query Editor

When editing objects you will often need to test your code and will often find yourself writing and executing T-SQL statements. SQLDBcontrol offers a feature-rich object editor that enables you to execute T-SQL statements against the currently connected database.

The object editor also offers syntax highlighting for T-SQL reserved key words. IntelliPrompt functionality, is also provided as well as detailed InfoTips for T-SQL functions.

Object-Level Permissions

Object-Level permissions are maintained as part of a given object's definition and it is possible to alter the permissions for any given object.

Object Editor

• Syntax Highlighting for T-SQL keywords
• Optional Line Numbering
• Split-Window functionality
• Optional Auto-case correct for T-SQL keywords (i.e. T-SQL keywords are automatically converted to uppercase as you type).
• Line modification markers and Line save markers.
• Optional IntelliPrompt functionality. For example, typing "select * from " will display an IntelliPrompt containing a list of all available tables in the current database.
• Optional InfoTip functionality, providing detailed InfoTips for all T-SQL system functions.
• Fully functional Query Results window that can be docked, pinned or undocked as desired.