Thanks for replies.  

Yelana's solution would indeed work but as it is an ongoing project and there will be many databases added to the system this way keeping the procs...