Miscellaneous preferences define behavior for creating Adaptive Server Enterprise nonsharable temporary tables while editing, running, or saving stored procedures or triggers. You can also indicate the default behavior for dropping and renaming objects, limiting connections to the database for Table Data Editor and SQL Scrapbooks, and monitoring server status.
| Property | Description |
|---|---|
| Show Warning Message if Trigger Is Being Renamed in Enterprise Explorer When Table Editor Is Open | Select Never to never show a message. Select Prompt to be prompted. |
| Show 'Reference will not be updated' Message When Database Object Is Being Renamed | Select Never to never show a message. Select Prompt to be prompted. |
| Close Opened Schema Object Editor After the Schema Object Was Dropped | Close editors as appropriate. |
| Max Connection Count | Limits the number of connections to the database for instances of Table Data Editor and SQL Scrapbooks in manual-commit mode. |
| Monitor Server Status |
Select Periodically Ping Database Server to Detect Whether Server Is Active to ping the database server to make sure the server is still running. Selecting this option might increase the size of the server log. Specify the interval for pinging the database server. You can indicate a value from 500 to 2147183647 ms. The default is 3000 ms. |
| Property | Description |
|---|---|
| Enable Autoexecute SQL Statement for Temporary Table(s) | Create nonsharable temporary tables automatically when the SQL statements to create them exist in the stored procedure or trigger (default). |
| Insert Table Creation Statements as Annotations (recommended) |
Set the New Temporary Table wizard default behavior to insert the SQL to create the table as a comment in the procedural object definition. This option is selected automatically when you select Enable Autoexecute SQL Statement for Temporary Table(s). |