>    Wish Adager had a PC version for MS-SQL :)

I wish the HP had a tool like MS Enterprise Manager.

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.


-----Original Message-----
From: Emerson, Tom [mailto:[log in to unmask]]
Sent: 29 September 2004 20:38
To: [log in to unmask]
Subject: Re: [HP3000-L] SQL commands like Adager dbschema listing?


> -----Original Message-----
> Behalf Of Art Bahrs
>
> Hi All :)
>     Anyone know how to "Blank" a MS-SQL database?  Need to
> create a blank copy of a database I inherited maintenance of ...

There are a couple of ways to do this.  You don't really need to know the
current structure (which is what I read as your implication here) because
most PC based databases are a single file -- just copy the file to a new
location, then erase the contents leaving the structure intact.  [issue the
SQL command "delete from <table>" for each table/dataset name -- by not
qualifying it with a WHERE clause, the result is to select and delete every
entry]



there are numerous "navigator" style tools for various PC-based databases
[some can even use ODBC to back into Image databases, but that's another
topic...]  These tools will show the structure, allowed users, etc., and
allow for manipulation of both the data and the structure.

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

==================================
This message contains confidential information and is intended solely for
the use of the individual or entity to whom it is addressed. If you are not
the named addressee you should not disseminate, distribute or copy this
email. Please inform the sender immediately if you have received this e-mail
by mistake and delete this email from your system. Email transmission cannot
be guaranteed to be secure or error-free as information could be
intercepted, corrupted, lost, destroyed, arrive late or be incomplete. The
sender therefore does not accept liability for any errors or omissions in
the contents of this message, which arise as a result of email transmission.
If verification is required please request a hard copy version. No contracts
may be concluded on behalf of Virgin Express SA/NV by means of email
communication. Finally, the recipient should check this e-mail and any
attachments for the presence of viruses. The company accepts no liability
for any damage caused by any virus transmitted by this email.
==================================

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