At 10:28 +0200 9/30/04, Richard Barker wrote:

> >    Wish Adager had a PC version for MS-SQL :)
>
>I wish the HP had a tool like MS Enterprise Manager.

You scream, I scream, we all scream for ice cream ;-)


>Just a small thing to add, I would follow Michael Gueterman advice for
>blanking or copying the DB, but just FYI, if you want to delete the contents
>of a table.  Use the TRUNCATE command, this will delete all the data in a
>table almost instantly without having to physically delete each record.
>It's much more efficient for large Tables.

One minor technical detail:  Do you mind whether your DATA stays on disk
or not?

"Almost instantly" sounds as if the POINTER to the data is marked "null"
(or whatever semi-equivalent method is used by each specific
implementation of the TRUNCATE command).

If this is what you wish, then you are all set.  If, however, you want
to be sure that you DELETE all traces of your data, then you may wish to
use a more time-consuming method that goes through EVERY bit and changes
it to something useless for spies.  This takes a bit of extra effort.

As with ice cream, you want to choose your flavor carefully.

Enjoy,

  _______________
 |               |
 |               |
 |            r  |  Alfredo                  http://www.adager.com
 |          e    |
 |        g      |  F. Alfredo Rego
 |      a        |  Manager, R & D Labs
 |    d          |  Adager Corporation
 |  A            |  Sun Valley, Idaho 83353-3000            U.S.A.
 |               |
 |_______________|

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *