SQL Server Lesson :1

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.