|Programming in MS SQL Server 2012|
RENAME Stored Procedure
In SQL Server Enterprise Manager Application, locate the (EBusiness) database and expand the node, click the Stored Procedures node in the left pane and in the right pane, right-click (usp_EmployeeList) name of the stored procedure and then type new stored procedure name.
Query Output Screen
sp_help is used to displays user-defined stored procedure information.
sp_helptext is used to displays user-defined stored procedure source code.
* * * * *