Tracking db usage?

25 Apr 2006 1:08 PM

Linn Kubler

Hi,

I originally posted this question in the programming group but then it
occured to me that this is probably the correct venue. I am trying to
create a report from a SQL Server 2000 database. My trouble is that I can't
quite figure out the relationship between various tables, I know there is an
intermediate table but I can't find it. The vendor documentation is not
complete so I'm trying to figure this out on my own. The vendor is not
responding to my emails.

So what I'd like to do is find a tool that, or figure how to, monitors the
database and can tell me when changes are made to the data. So that I can
run our application, make a change and see which tables are affected. Is
there a way to do this? Does Microsoft supply some tool that helps track
these kinds of activities? My budget it very limited so a free tool would
be best.

Thanks in advance,
Linn

25 Apr 2006 2:46 PM

Sue Hoegemeier

You can use Profiler (or server side traces) tools which are
available in SQL Server to track what statements are being
executed when you perform different activities in the
application. There are several topics in books online under
SQL Profiler that explain Profiler and how to use it.

-Sue

On Tue, 25 Apr 2006 08:08:39 -0500, "Linn Kubler"
<lkub***@chartwellwisc2.com> wrote:

Show quote

>Hi,
>
>I originally posted this question in the programming group but then it
>occured to me that this is probably the correct venue. I am trying to
>create a report from a SQL Server 2000 database. My trouble is that I can't
>quite figure out the relationship between various tables, I know there is an
>intermediate table but I can't find it. The vendor documentation is not
>complete so I'm trying to figure this out on my own. The vendor is not
>responding to my emails.
>
>So what I'd like to do is find a tool that, or figure how to, monitors the
>database and can tell me when changes are made to the data. So that I can
>run our application, make a change and see which tables are affected. Is
>there a way to do this? Does Microsoft supply some tool that helps track
>these kinds of activities? My budget it very limited so a free tool would
>be best.
>
>Thanks in advance,
>Linn
>

25 Apr 2006 2:49 PM

Jens

Hi, yes sure, use the profiler to get the queries issued against the
database.

HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---

26 Apr 2006 3:16 PM

Linchi Shea

Your post seems to imply two things: (1) you want to track data changes, and
(2) you want to track schema changes.

As other mentioned, you can certainly run SQL Trace to track all these
changes. We run our audit using SQL Trace scripts. So that for sure works.
For schema changes, if they don't happen often, you can also take snapshots
of the system tables and compare these snapshots to see the differences. The
third method is to script out all the objects regularly, and compare the
scripts.

Linchi

Show quote

"Linn Kubler" wrote:

> Hi,
>
> I originally posted this question in the programming group but then it
> occured to me that this is probably the correct venue. I am trying to
> create a report from a SQL Server 2000 database. My trouble is that I can't
> quite figure out the relationship between various tables, I know there is an
> intermediate table but I can't find it. The vendor documentation is not
> complete so I'm trying to figure this out on my own. The vendor is not
> responding to my emails.
>
> So what I'd like to do is find a tool that, or figure how to, monitors the
> database and can tell me when changes are made to the data. So that I can
> run our application, make a change and see which tables are affected. Is
> there a way to do this? Does Microsoft supply some tool that helps track
> these kinds of activities? My budget it very limited so a free tool would
> be best.
>
> Thanks in advance,
> Linn
>
>
>