One solution is to add the stored procedures to the master database, and add sp_ prefix to their names

(bad practise)

Another solution is to use a tool to sync the stored procedures between the various databases.

Third solution is to use dynamic sql and use three part names like customerdb1.dbo.sometable

None of the above solutions (maybe apart from the second) are nice though.

Regards,

Andras