SQL Server database last updated date time

sql sql-server database sql-scripts
Nagendra Baliga picture Nagendra Baliga · Apr 9, 2015 · Viewed 72.6k times · Source

Is there any sql script to find out when the database in SQL server is last updated?

I want to know the last updated date time for the changes done on meta data of the database rather than actual data inside the table. Particularly when:

  • Any new table is created/dropped from Database.
  • Any new column is added/removed from table in the Database.
  • Any new views/Stored Procedures/Functions are added/altered inside the Database.

Answer

Daniel Stackenland picture Daniel Stackenland · Apr 9, 2015

Look in sys.objects should be enough, try this query

 select * from sys.objects
order by modify_date desc

Related questions

How to switch database context to newly created database?

I wrote a script to create a database: 1: USE master; 2: IF (db_id('myDB') is null) 3: CREATE DATABASE myDB; 4: USE myDB; but it does not work... I got an error: Could not locate entry in sysdatabases for database 'myDB'. No …

Read More
Reset identity seed after deleting records in SQL Server

I have inserted records into a SQL Server database table. The table had a primary key defined and the auto increment identity seed is set to “Yes”. This is done primarily because in SQL Azure, each table has to have …

Read More
How do I list all the columns in a table?

For the various popular database systems, how do you list all the columns in a table?

Read More