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 |
|
pab123
Starting Member
1 Post |
 Posted - 2008-10-21 : 09:24:38
|
| Hi,I'm looking for a SQL query in order to find:- the last shrink (Shrink Database Task) date of a database- the last cleanup (Maintenance Cleanup Task) date of a database- the last rebuild indexes (Rebuild Index Task) date of a databaseThe goal is to develop a monitoring program. I've to connect to about 40 servers and get these information for all datases.Thanks for your supportBest regards, |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-21 : 10:13:33
|
| Can't you get these info from your jobs if you have set it as a job? |
 |
|
|
|
|
|
SQL Server 2005 - get database properties