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 |
|
mk_garg20
Constraint Violating Yak Guru
343 Posts |
 Posted - 2004-09-02 : 19:46:04
|
| How we can get time when tables were reindexed?Thanksmk_garg |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-02 : 19:46:33
|
| You can't unless you stored this in a table somewhere when you ran the command or check the job history if you have a scheduled job.Tara |
 |
|
|
mk_garg20
Constraint Violating Yak Guru
343 Posts |
Posted - 2004-09-02 : 19:56:08
|
| Never scheduled any job. Trying first time today.Stored Procedure for reindexing is also given by you.Thanks!mk_garg |
|
|
|
The Enigma
Posting Yak Master
179 Posts |
|
|
mk_garg20
Constraint Violating Yak Guru
343 Posts |
Posted - 2004-09-03 : 02:33:18
|
| Enigma,I just had a look at above link.That guy is funny.Dont have faith in code given by Tara.Still except someone else will give full proof code.mk_garg |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2004-09-03 : 03:38:28
|
| The amusing thing is that the index defrag code did only do one index per table, but she revised the code and now it works perfectly. Some people just want the world on a plate, methinks.-------Moo. :) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-03 : 12:06:30
|
| Brett e-mail me that link. Too funny. I wouldn't trust anyone's code either unless I tested it out first. If you aren't comfortable with my code, then instead of executing it, do a PRINT @SQL to see the results. Once you are comfortable the results give you what you need, then do the EXEC @SQL.Tara |
|
|
|
|
|
|
Reindex tables