Let us suppose that one of users of a database run some process. Can
administrator see and kill this process? And if "Yes", how?

In SchemaSpy I attempt to provide row counts for every table to help in
the analysis of a schema, especially when evaluating indexes.
I had a user submit a "feature request" that the code that does this
count blows up when it tries to evaluate a table with nested tables.  I

I have some COMs developed in Visual Basic. These COMs access to an
Oracle DB with ADO. it isn't set the Isolation level of the transaction
on the ADO Connection and i think that ADO use the default Level "Read
Committed".

I am an experienced Access user who has worked as an Access Developer
at a Junior level.
I work for a small charter airline which has recently bought a bespoke
SQL Server database to manage all aspects of the business: Sales,

I'm new to database design, I've done some reading and think I have come
up with the most natural database schema for my application, but I'm not
sure if the approach I'm taking is practical. I would appreciate some
advice before ploughing ahead.

I'm using mysql v 4.0.something (so no subselects :( )
I have a table of shoppingcarts, and a table of cartitems.  cartitems
have the cartuid of the shoppingcart they're in.  Pretty simple, right?
if I do:

Extreme Markup Languages 2005
August 1-5
Montreal, Quebec, Canada
http://www.extrememarkup.com

Hi I am doing an IT course through a TAFE college here in brisbane
Ausrtralia.  The course is Certificate III in Information technology
(Software applications).  It deals with the Advanced area od MS Word, Excel,
aand obviously Access.  I am now at the Acces stage of the course, and ...

I need some advice from people with experience in a number of different
databases.
Background: Application is running MsSQL Server on central database:
Main server and failover server. DB server-side application access MS

That problem comes from biosciences, here I present a simpler version.
The story is about beads.
* A single necklace is composed of a couple of strings with beads,
appx. 3-10 strings in one necklace

Apologies if I'm posting this to the wrong group -- feel free to
redirect me.
I've got what I believe are old DBase/Foxpro files (DBFs, plus CDX and
FPT files) that I want to extract the data from.  I have MS Access

There are two columns in a database table. These two columns are of
type TEXT. They store the FROM and TO values for a certain range. These
values are exceptionally large and cannot be stored as numeric values.
Each range is mutually exclusive and does not overlap. You are free to

I currently manage a number of Microsoft Access databases on behalf of my
employer.
Recently a large number of the users transferred to another site.  As the
database is on the company network they can still conect to it via the

I am trying to write a sql statement that gives me the records that
have multiple values for column b, but cannot figure it out - can
someone help?
My table is as follows:

(First off, sorry for posting here, my news carrier doesn't have any
(English) mysql groups.)
I'm trying to do a MAX for each group, to find the biggest object for
each group: