November 6, 2012 at 7:19 am
I wanna confirm that some user are manually executing below query on each databases one by one
This may be the right approach...
[EXEC sp_MSforeachtable @command1="print '?' DBCC DBREINDEX ('?', ' ', 80)"]
Now my question is instead of using the above query...how about using a Maintenance plan for Rebuilt Index?
************************************
Every Dog has a Tail !!!!! :-D
November 7, 2012 at 6:06 am
:w00t:
No reply 🙁
************************************
Every Dog has a Tail !!!!! :-D
November 7, 2012 at 6:12 am
Use Ola's index maintenance scripts, give you a lot more control than the standard MP's do.
Link can be found in my signature.
November 7, 2012 at 6:17 am
Hi,
can u please copy paste the scripts n steps here... the link is blocked in my office :w00t: & at home i have no internet 🙁
************************************
Every Dog has a Tail !!!!! :-D
November 7, 2012 at 6:24 am
I would seriously recommend getting them to unblock the site then as there is just to much information on that site to copy and paste into the forum
November 8, 2012 at 5:12 am
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply