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
    seemun, Apr 12, 2010
    #2

  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
    Madhivanan, Apr 13, 2010
    #3

  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
    seemun, Apr 14, 2010
    #4

  4. satya Moderator

    Why you are particular about TSQL for that when you have such an facility with DMVs?
    satya, Apr 19, 2010
    #5

Share This Page