My concern was, that I, (the administrator) do not accidentally truncate the table.

I almost did that, thinking I was on my test database, but I caught myself on time.

Im thinking...

I have a table with millions of records without any foreign key.

I want to prevent an accidental truncate on this table.

I was hoping there is a way I can write a...

I think it is mainly due to inserts, updates, and deletes. We have alot of modification on our databases so I have to run index defrag /re-index every week.

Max

Found the solution.  The disconnection error on Enterprise Manager when creating a new job was due to Norton Anitvirus software.  If you temporarily disable the Norton anitvirus, you can create...

The query time-out is already set to infinite.