last update of database

DB - SQL2000 or SQL7
OS - W2K or NT
Is there a sp or any way to check when a database is last accessed by or
updated by user ?
TIA
No, SQL Server doesn't track this information, unless you want to use a
third party tool to review the transaction logs. You can put code into your
own procedures, or triggers on tables if you for some reason allow direct
access to tables, to track whatever components of the transaction you like.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"pohkeat" <pohkeat@.hotmail.com> wrote in message
news:e7DI$JeNEHA.556@.tk2msftngp13.phx.gbl...
> DB - SQL2000 or SQL7
> OS - W2K or NT
>
> Is there a sp or any way to check when a database is last accessed by or
> updated by user ?
> TIA
>
>

last update of database

DB - SQL2000 or SQL7
OS - W2K or NT
Is there a sp or any way to check when a database is last accessed by or
updated by user ?
TIANo, SQL Server doesn't track this information, unless you want to use a
third party tool to review the transaction logs. You can put code into your
own procedures, or triggers on tables if you for some reason allow direct
access to tables, to track whatever components of the transaction you like.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"pohkeat" <pohkeat@.hotmail.com> wrote in message
news:e7DI$JeNEHA.556@.tk2msftngp13.phx.gbl...
> DB - SQL2000 or SQL7
> OS - W2K or NT
>
> Is there a sp or any way to check when a database is last accessed by or
> updated by user ?
> TIA
>
>

last update of database

DB - SQL2000 or SQL7
OS - W2K or NT
Is there a sp or any way to check when a database is last accessed by or
updated by user ?
TIANo, SQL Server doesn't track this information, unless you want to use a
third party tool to review the transaction logs. You can put code into your
own procedures, or triggers on tables if you for some reason allow direct
access to tables, to track whatever components of the transaction you like.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"pohkeat" <pohkeat@.hotmail.com> wrote in message
news:e7DI$JeNEHA.556@.tk2msftngp13.phx.gbl...
> DB - SQL2000 or SQL7
> OS - W2K or NT
>
> Is there a sp or any way to check when a database is last accessed by or
> updated by user ?
> TIA
>
>

last time a table was used

Any way without a trigger to determine the last time a table was accessed? we have duplicate tables accross some databases, and suspect we don't need a few of them. ;)

They won't let me change the names and see who squeals.

Sql profiler?!|||

Yeah, forgot to mention I only have developer rights.

<<sigh>>

I was hoping there was an additional magic microsoft faerie out there that would somehow know.

sql

Last table date access

I need to know the last time each table on my database was accessed or
modified. Is that possible? I'm usign SQL Server 2000.Not unless you have been running a trace for a while.
Andrew J. Kelly SQL MVP
"Huacuz" <Huacuz@.discussions.microsoft.com> wrote in message
news:C640BB82-4F63-4B41-9600-BAEED7396F57@.microsoft.com...
> I need to know the last time each table on my database was accessed or
> modified. Is that possible? I'm usign SQL Server 2000.|||Hi
If you want an off the shelf product you could look at AuditDB from Lumigent
http://www.lumigent.com/Products/auditdb_sql.html
John
"Huacuz" wrote:

> I need to know the last time each table on my database was accessed or
> modified. Is that possible? I'm usign SQL Server 2000.|||What is your definition of 'accessed'; perhaps any time any process selects
a row for any reason?
"Huacuz" <Huacuz@.discussions.microsoft.com> wrote in message
news:C640BB82-4F63-4B41-9600-BAEED7396F57@.microsoft.com...
> I need to know the last time each table on my database was accessed or
> modified. Is that possible? I'm usign SQL Server 2000.|||> I need to know the last time each table on my database was accessed or
> modified. Is that possible?
Not without using Profiler or 3rd party auditing tools, no.

Last Table Access

How do I determine who last accessed a SQL 2000 table?See this quite related article.sql

Last Date Used

I am trying to generate a report listing data base and tables within the
data base when last accessed, updated or modified. Does anyone know of
a tool that performs this function?
Ernie
A Plan without Action is a DayDream
Action without a Plan is a Nightmare
*** Sent via Developersdex http://www.codecomments.com ***
Hi,
SQL Server will not store this information. For doing this you need to
enable the profiler, store the output into a table and then do the
analysis manually to get the report.
Thanks
Hari
SQL Server MVP
"Ernie" <nospan@.devdex.com> wrote in message
news:OUTJ%23INUFHA.584@.TK2MSFTNGP15.phx.gbl...
> I am trying to generate a report listing data base and tables within the
> data base when last accessed, updated or modified. Does anyone know of
> a tool that performs this function?
> Ernie
> A Plan without Action is a DayDream
> Action without a Plan is a Nightmare
> *** Sent via Developersdex http://www.codecomments.com ***

Last Access to the Database

Is there a tool for SQL Server 2000 that will tell me the last time all the
databases were accessed on the server? I'm trying to detemin which databases
are not used anymore or not very often.
Thanks,
David
======================================
David McCarter
www.vsdntips.com
VSDN Tips & Tricks .NET Coding Standards available at:
www.cafepress.com/vsdntips.20412485
dotNetDave (dotNetDave@.discussions.microsoft.com) writes:
> Is there a tool for SQL Server 2000 that will tell me the last time all
> the databases were accessed on the server? I'm trying to detemin which
> databases are not used anymore or not very often.
No, there is no such feature.
If you are an evil man, you use set the databases offline, and see how
many people scream.
If you are more the conflict-avert sort of person, you can set the
suspected databases to autoclose. If memory serves, you can then trace
an access by looking at the dates for the MDF files. But there is a
catch here: if anyone browse the list in EM and is not sysadmin, EM
will have to open the DB to see if that person has access. Or it could
be due to any other random visit.
Slightly more reliable is to run a trace, but you may need to run it
for three montns or so.
Personally, I think being evil is a good qualification for a DBA. :-)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx