Show last modified date in Management Studio

I am using SQL Server 2005.  In Management Studio, I can see the date a Table, SPROC or View was created, but is there any way to show the last modified date?
LVL 1
wsturdevAsked:
Who is Participating?
 
imran_fastCommented:
@EugeneZ
In Sql 2005 management studio there are reports which are part of sql managment studio and those reports give all these required information.
0
 
Eugene ZCommented:
No,
there is not such field
0
 
imran_fastCommented:
you'll be able to see this information along with auditing of all of the other objects in SQL Server 2005.
click on your database on sql managemnt studio and then click f7
then you will able to see the summary page on that page then in reports click on schema changes history.
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
Eugene ZCommented:
you can use 3rd party tools such as idera sqlcomplince manager
or DDL Triggers , etc
0
 
Eugene ZCommented:
imran_fast -good one
It is true and the report is working from SSIS for sql server 2005
but sql server 2000
---------------
0
 
imran_fastCommented:
@eugenez
but for sql server 2000 nothing is there.
0
 
Eugene ZCommented:
it is true
0
 
wsturdevAuthor Commented:
imran_fast --

Sorry for the delay.  I jsut got back to this issue, and when I followed your instructions, I see the following list:
Database Diagrams
Tables
Views
Synonyms
Programmability
Service Broker
Storage
Security

but no Reports.
0
 
wsturdevAuthor Commented:
I found the reports capability and the Schema Change history, but how do I change the date so I can go back a few weeks, and not just a couple of days?
0
 
imran_fastCommented:
it will give all the changes related to particular object since its creation.
0
 
wsturdevAuthor Commented:
And a Restore is considered a Creation?  I restored an older backup and when I went in the only schema change on record was the drop of the database I was restoring, and the date time was that of the restoration.

I there a setting I can use so I can see all activity in a restored database as if I had never backed it up and restored it?
0
 
wsturdevAuthor Commented:
Unfortunately, I have come to find out that the reports are tied to the currently active trace, and since the trace on my development copy of SQL Server gets reset frequently, it does not provide the longer term information I want.

However, I found out this will give me what I want:

SELECT name, modify_date FROM sys.views  [or sys.tables, etc.]
order by modify_date desc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.