>I think the problem I need to resolve is to figure out how to programatically "use {dbname}". If there is a way to do this, then I could put everything back into one SP.
TSQL does not allow parameterization of the USE statement. You cannot use Dynamic SQL because the database will only be changed for that batch. Thus my idea to change the database and call a system stored procedure.
-Mike