SQL Server Performance

How To Locate Last Access To The Object

Discussion in 'SQL Server 2008 General Developer Questions' started by seemun, Apr 12, 2010.

  1. seemun New Member

    Hi,
    Can anyone tell me how to locate the last access for the object (eg: Table, Store Procedure, Function, etc).
    rgds/sm
  2. Madhivanan Moderator

    [quote user="seemun"]
    Hi,
    Can anyone tell me how to locate the last access for the object (eg: Table, Store Procedure, Function, etc).
    rgds/sm
    [/quote]
    Read about Dynamic Management View in SQL Server help file
    Some of them will help you
  3. seemun New Member

    Hi,
    Can you provide the SQL syntax in order to locate the last access for the object (eg: Table, Store Procedure, Function, etc).
    rgds/sm
  4. satya Moderator

    Why you are particular about TSQL for that when you have such an facility with DMVs?

Share This Page