SQL Make Stored Procedures available across databases, or affect other databases

Create stored procedure in Master database.
Prefix it wit 'sp_' so sql identifies it as a public stored procedure.
Explicitly name your database objects in the stored procedure.