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?
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center