vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hi Erland, I was able to get the script running. It was a lot of work in sql 7.0 as the SHOWCONTIG doesn't support table results and it outputs as a print message. I was able to get around it using OSQL and xp_cmdshell. Let me ask you another question. What is your opinion of INDEXDEFRAG on sql 2000? BOL says it doesn't require an exclusive lock as DBREINDEX. But is there any drawback in substituting INDEXDEFRAG over DBREINDEX? Thanks. |