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 |
|
ksr39
Posting Yak Master
193 Posts |
 Posted - 2011-09-07 : 10:38:18
|
| Hi All,I need a small help 1) How can I find when my database is updated with updates statistics?2) When is my database index are reorganized or rebuild?3) How to know when my database is been shrunk?As there is no Maintenance plan for this. I just wanted to know when all this is happened on my user databases.is there any query to get the information.Thanks In Advance. |
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2011-09-07 : 10:49:05
|
I'd suggest you search the site first before posting as there will be a wealth on information on stuff like this, just stops the site being clogged up
http://weblogs.sqlteam.com/joew/archive/2007/08/31/60316.aspx-----------------------------------------------Learning something new on SQL Server everyday. |
 |
|
|
|
|
|
Check The Integrity and index on a database