Hi
I have some code which loops through all databases on a given server. It collects various bits of information for the server and stores that in a database. Think of it as a catalog/portfolio database. However on occasion a database requires or is being consistency checked. This causes not only the agent but the entire client to crash.
Does anybody know a way I can check to see if a database is being consistency checked or if it requires a consistency check? If not is there a way to prevent the entire client from crashing and moving on to the next database?
Thanks in advance for your help.
Azam