If any user-created stored procedure has the same name as a system stored procedure, the user-created stored procedure will never be executed.
That is:
USE Kiran_DB
GO
CREATE PROCEDURE sp_who
AS
PRINT 'Some Text'
GO
EXECUTE sp_who
Will not print the above text.
This will still return information about current SQL Server users and processes.
