I have a table in my database that is constantly monitored by an application server for changes. Unfortunately rebuilding the indexes connected with this table breaks the app server's connection. This causes print jobs and various other processes to fail silently on the application server.
I have created a small monitoring SQL job that lets me know when this happens, but I would prefer to prevent it from happening in the first place.
I need to rebuild indexes weekly for performance reasons, but I would be fine with skipping the indexes associated with that table.
How can I rebuild indexes for the rest of the database without touching that table?
Edit: I am currently using an SSIS job (the canned maintenance plan) to rebuild all indexes for all tables in the DB. After that it updates stats and checks integrity.