http://searchsqlserver.techtarget.com/expert/KnowledgebaseAnswer/0,289625,sid87_gci1111272_mem1,00.html In the above article, it shows how to loop through each database. My question is, how would I loop through each database so that I can then use the sp_foreachtable? I am trying to use the following on each database on a server. “execute sp_MSforeachtable @command1='DBCC DBREINDEX ([?], '''', 100)'”
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!