Friday, May 12, 2006 10:22 AMWhen running a maintenance plan that includes rebuilding index's it fails on the rebuild index but does not show on which table/indexed view the error occured. How can I find this out
Monday, August 06, 2012 8:14 AM
run xp_readerrorlog and paste the error,so that we can understand it perfectly
Ramesh Babu Vavilla MCTS,MSBI
Monday, August 06, 2012 11:03 AMshare the error mesasge you are getting.
Please click the Mark as Answer or Vote As Helpful if a post solves your problem or is helpful!
Monday, August 06, 2012 1:43 PMInstead of Rebuilding/Reorganizing all indexes try to write down Query for it and execute it through SQL Server job with proper print statements so that you can reach to exact error line.