I find the best way to do this is set up the ODBC to the site
database, go into Access and link to all the tables. Then poke through
them and get a feel for what is going on. Most of the tables about
hardware match up with the hardware categories in the Resource
Explorer. It's actually really easy to build decent queries against
it. Especially now under SQL7 that that 15 table join limit seems to
be gone (I could be wrong here).
On Tue, 6 Jul 1999 08:30:18 +0100, "Martin Gooding"
>Silly question, I want to query the SMS database via SQL queries either in
>Access or something like that.
>Where can I find any information on the SQL tables in the SMS database and
>Thanks for any help,
>Bull Information Systems