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

Note:
sp_help is used to displays user-defined stored procedure information.
sp_helptext is used to displays user-defined stored procedure source code.

* * * * *

Email Your Comment To AUTHOR

Quick Links
Home
About Me
System Analyze Method
Dimensional Data Model
Entity Relationship Model
Relational Database Model
Tutorials
MS SQL Server - DBA
SSIS - Video Tutorials
SSAS - Video Tutorials
SSRS - Video Tutorials
SQL Server White Papers
Programming in SQL Server
Help Us
Contact Me
R.K.Prem Nath
Madurai District
Tamil Nadu, India

[email protected]
[email protected]
Terms Of Use                                                  Protected by Copyscape Online Plagiarism Tool             Copyrights © . Data-e-Education. All Rights Reserved.