Welcome dear readers you will find good technical information here

Procedures created in the master database

Home
How to Querying the SQL Server System Catalog FAQ
Tax Savings
Partitioning Tables and Indexes
Top 10 Traders
master database
Datawarehousing Tips
MS SQL Server Database Free Tools
Table and Index Architecture
Fundamental unit of data storage in Microsoft SQL Server
SQL Server Articles
Transaction Management Overview
Under Construction

Procedures created in the master database - accessibility from other user databases

 
EXEC master.sys.sp_MS_marksystemobject 'sp_Raman';
You can read about sp_MS_marksystemobject in Books Online.
 
If you want to see if all the procedures are going that route to disabel that you can use this command.

--Turn system object marking on
EXEC master.dbo.sp_MS_upd_sysobj_category 1
to stop that behavior run this command:
--Turn system object marking off
EXEC master.dbo.sp_MS_upd_sysobj_category 2

USE MASTER
GO
SELECT * FROM sys.objects WHERE NAME LIKE 'SP_%' AND sys.objects.is_ms_shipped = 0
SELECT * FROM sysobjects WHERE sysobjects.[name] LIKE 'SP_%' and category = 0
 
 
Examples:
USE master
CREATE TABLE Employee (EmpName VARCHAR(50))
INSERT test VALUES('master_BillGates')
go
CREATE PROC sp_Raman AS
SELECT * FROM Employee
GO
USE northwind
CREATE TABLE Employee (EmpName VARCHAR(50))
INSERT Employee VALUES('northwind_BillGates')
USE pubs
CREATE TABLE Employee (EmpName VARCHAR(50))
INSERT Employee VALUES('pubs_BillGates')
USE pubs
EXEC sp_Raman --returns 'master_BillGates'
USE master
EXEC sp_MS_marksystemobject sp_Raman
USE pubs
EXEC sp_Raman --returns 'pubs_BillGates'
USE northwind
EXEC sp_Raman --returns 'northwind_BillGates'
 

Enter supporting content here