Finding out how many times a table is accessed

wotan

We have an application that accesses a particular table, but it is
never updated. Without stepping through the complex application code,
is there a method of logging when a particular table is accessed?

Jul 20 '05 #1

Subscribe Post Reply

2116

How do you access the table? If you use stored procedure (and you should)
you could make additional table and insert data in it each time the stored
procedure is executed.
MC
"wotan" <wo******@hotmail.com> wrote in message
news:e5**************************@posting.google.c om...

We have an application that accesses a particular table, but it is
never updated. Without stepping through the complex application code,
is there a method of logging when a particular table is accessed?

Jul 20 '05 #2

Simon Hayes

"wotan" <wo******@hotmail.com> wrote in message
news:e5**************************@posting.google.c om...

We have an application that accesses a particular table, but it is
never updated. Without stepping through the complex application code,
is there a method of logging when a particular table is accessed?

Probably the quickest and easiest way is to create a trace with Profiler -
you can filter on the table name and the word SELECT, for example. See Books
Online for more information.

Simon

Jul 20 '05 #3

wotan

"MC" <marko_culo#@#yahoo#.#com#> wrote in message news:<cf**********@brown.net4u.hr>...

How do you access the table? If you use stored procedure (and you should)
you could make additional table and insert data in it each time the stored
procedure is executed.
MC
"wotan" <wo******@hotmail.com> wrote in message
news:e5**************************@posting.google.c om...
We have an application that accesses a particular table, but it is
never updated. Without stepping through the complex application code,
is there a method of logging when a particular table is accessed?

It's a VB6 based application, so the access is done through that.
Basically, the application is quite old, so enhancements have been
done to it over the years, making some things - such as this - quite
hard to establish

Our new generation software does use SP's, so you're right that it
would be easier to do.

Jul 20 '05 #4

Similar topics

Finding if a REAL is LIKE '%[49]9'

by: Aaron W. West | last post by:

Timings... sometimes there are almost too many ways to do the same thing. The only significant findings I see from all the below timings is: 1) Integer math is generally fastest, naturally....

Microsoft SQL Server

Difference between a 'file' and a 'table'

by: John Bailo | last post by:

With OS400, all files are objects that can be accessed relationally. When I view the file system from Navigator (windows client), I see there is the Database and SQL tables, then there is the...

DB2 Database

Access not finding linked tables

by: Internet Arrow Limited | last post by:

Hi, I have a requirement to write an access application that must run under access97 and access2K. Some users will use Acess2K to access data that will also be accessed by Access97 users. The...

Microsoft Access / VBA

Finding Real Worksheet Name After Access Export

by: Anthony Cuttitta Jr. | last post by:

I'm working on some procedures where Access queries are exported to Excel, and then later on, those same workbooks are openned, and I need to target a specific original sheet. Sometimes there will...

Microsoft Access / VBA

Finding duplicates

by: Maxi | last post by:

I have 100 tabes in an Access database, every table has 1 filed with 100 names (records), no primary key assigned. I would like to find duplicates. Here is the criteria: The computer should...

Microsoft Access / VBA

FindFirst and query not finding records - date values

by: rivka.howley | last post by:

I wrote some code that creates a table with a date/time field at 15-minute intervals. Here's how I create and populate the table With tblDataTemp ..Fields.Append .CreateField("CT_ID", dbLong)...

Microsoft Access / VBA

what is needed to implement a memory table?

by: monkeydragon | last post by:

what is needed to implement a memory table, that will be accessed later via reference "label". for example, i read the NUMBER of DATA the table will have and along with it the DATA itself in a...

C / C++

Statistics IO logical reads sometimes 15 million and other times down to 90 thousand?

by: serge | last post by:

I am running a query in SQL 2000 SP4, Windows 2000 Server that is not being shared with any other users or any sql connections users. The db involves a lot of tables, JOINs, LEFT JOINs, UNIONS...

Microsoft SQL Server

Finding if a file is less than 24 hours old

by: timnels | last post by:

Is there a simple way using the File class to see is a file is older than 24 hours?

C# / C Sharp

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA