Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Posts
    94

    Question Unanswered: table and sp last used

    Hi,

    Is there any way I can find out the table and a stored proc last used?

    pl let me know...

    Regards,
    Ram.

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    If you capture MDA information, you can query the reporsitory on the tables and procs used.

    Another approach is if you have recompile ON on proc, I'm thinking of dbcc procbuf, will have the last recompile time on it. You can look at the most recent timestamp.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •