-
Database Maintenance Plan - Index Rebuild
Does anyone know the actual t-sql script that runs in the indexing part of a maintenance plan?
-
check BOL for DBCC DBREINDEX
-
BOL??? what is BOL? and I tried running DBCC DBREINDEX prior to posting my original question, however it appears as if you can only run said command against a specific table...not the entire database. I believe the job within the maintenance plan runs against the entire database.
-
BOL is sql books online, and you can rebuild index on the db with this one:
sp_MSforeachtable 'dbcc dbreindex("?")'
-
does it really do it
How can we see that it works. any suggestions
I couldnt find this sp_msforeachtable
on my BOL
-
You can check job history, and sp_MSforeachtable is undocumented.
-
thnks alot
You should write articles on undocumented processes
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|