As a troubleshooting and repair tool, Connect Daily has a SQL Command window that allows you to execute SQL Statements directly against the database. To access the window, choose SYSTEM | CONFIGURATION | DATABASE CONFIGURATION and click on the SQL Command Window button.
Improper use of this tool can cause loss of data. In general, you should not use this feature unless you have been directed to by technical support personnel.
Type or paste the SQL Statement into the text area. If the statement is an update statement, set the Statement Type option to Exec. If the query returns rows (SELECT statement), leave it on the default of Query.
If you run an update statement with the type set to query, the statement will still execute; it's just that the page will issue a useless error message.