The same metaphor does not hold for SQL Server. A stored procedure is owned by a specific database. There is one exception: any stored proceduret that begins with sp_ is considered a system stored procedure. It has visibility across all databases. They exist within the master database but affect the database where they're being called from.

Now, you can reference an object in another database by qualifying the object with the database name: database.owner.object_name

-Mike