In the Object Explorer, clicking on a table from the Tables tab > click on the Script tab.
It generates a script to create the table object.
Leaving PC alone and keeping TOAD open creates a transaction that keeps the database open.
Running a job looks for open transactions more than 90 minutes open.
This is dangerous because that transaction is kept open it holds a pointer in the log, and eventually the database will not be able to flush the log.
The database will run out of log space, bringing the database to a halt.
Is there some setting that needs to be set to tell it not to keep this transaction open when TOAD does not actually appear to be doing anything?
