Solved

How to find out when was the last time a database table was accessed by a user

Posted on 2011-03-25
2
409 Views
Last Modified: 2012-08-13
I'm trying to find out when was the last time that a specific database and its tables was accessed by a user.  Details as following:
There are about 30 databases on SQL 2000 server, and I'd like to get rid off some before upgrading to SQL 2005.  I want find out which database(s) has not been used for more than 12-month.  In addition, is it possible that I can narrow it down to table/stored procedure level, i.e. which table or stored procedure has not been used for past 12-month.
0
Comment
Question by:suebarner
2 Comments
 
LVL 5

Expert Comment

by:bitref
ID: 35219284
You must first start a trace for the required database objects. Otherwise, it is impossible to get an answer.
0
 
LVL 40

Accepted Solution

by:
Sharath earned 500 total points
ID: 35219866
You can check this URL : http://www.sqlservercentral.com/scripts/Administration/69438/
http://www.eggheadcafe.com/software/aspnet/31209031/sql-server-2000-index-usage.aspx
But the problem is you are currently on SQL Server 2000 and sys.dm_db_index_usage_stats is not available on 2000.
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question