Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
grandhi
Starting Member
31 Posts |
Posted - 2013-06-19 : 14:20:21
|
Hi All, I want to know,last modification time of Database in MS Sqlserver 2012.How can I find?Already I checked all properties of the database,creation time is there but it's not providing last modification time.How can I find this?Thanks |
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-06-19 : 14:27:40
|
It depends on what you mean by database modification time. If it is data modification time (ie, new rows inserted, existing rows updated or some rows deleted), there is no reliable way unless you are auditing the changes.If you are interested in schema changes, you can use the standard Schema Change History report. Right click on the database name, Reports -> Standard Reports -> Schema Change History. |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2013-06-19 : 14:28:04
|
What kind of modification? To the DB Settings? To a DB object? To Data? |
|
|
grandhi
Starting Member
31 Posts |
Posted - 2013-06-19 : 14:37:24
|
In my point of you,database modification means,If you do anything(like creating new tables,deleting tables,adding rows in tables,modifying data in tables and deleting data in table)inside DB indirectly database status(modification time) was changed.I want to know that time.I hope,you understand what i said.Thanks |
|
|
|
|
|
|
|