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'