Hi Ron Howerton,
What you have to do is simply fine tune your all the store procedures.
are you calling any functions in your store procedures. if yes then its bad practice. instead of calling the function from SP's simply write them in you sp.
make sure with up to 100 rows none of your store procedure/function/view/cursor/Triggers should take more then 2 sec. if it is then there is some prob. as the number of rows get increasing, it will lead to the same error.
so please fine tune all of your store procedure/function/triggers.