Home / server / Questions / 189184
Accepted
osij2is
Asked: 2010-10-09 11:59:18 +0800 CST

Find last access datetime stamp for objects in SQL Server 2000 database

  • 772

I'm in the planning stage/phase of migrating one of our SQL Server 2000 databases to 2008. Our database holds numerous tables (hundreds) and stored procedures (hundreds). I'm trying to figure out which are in use and which are not. My first guess was to look in the sysobjects table and see if there's a field that stores the a 'last accessed' but I can't seem to find anything within the MSDN documentation.

What's the best way to go about investigating which objects are in use or not in SQL Server 2000?

sql-server migration database

2 Answers

  1. Best Answer

    Out of luck. No way. SQL Server does not track usage timestamps for objects.

    • 1

  2. USE YourDatabaseHere;

    GO

    SELECT name, create_date, modify_date

    FROM sys.objects

    GO

    I think this is what you are looking for?

    EDIT:

    http://www.sqlteam.com/article/using-ddl-triggers-in-sql-server-2005-to-capture-schema-changes - a DDL way which may better suit the requirement....

    • 0