maintenance plan - rebuild index fail

Question

When 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

Answer 1

run xp_readerrorlog and paste the error,so that we can understand it perfectly

---

Ramesh Babu Vavilla MCTS,MSBI

Answer 2

share 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!

Answer 3

Instead 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.