tuchfeld

<div>
Thanks, Raja Jegan R.<br />
I wonder.. are you saying that procedures with CREATE cannot be edited?
</div>


Thanks, Raja Jegan R.
I wonder.. are you saying that procedures with CREATE cannot be edited?

<div>
To clarify, If you right click on a Procedure and Choose Modify, then it will create ALTER PROCEDURE statement only and not CREATE PROCEDURE statement. If it comes as CREATE, then you would need to modify that to ALTER to get it work..<br />
<br />
Out of curiosity, what is the SSMS version you have as I havne't seen this behavior across any SSMS versions.<br />
Try updating SSMS to the latest version and check once..<br />
Also if possible, share us the procedure which is giving you problems so that we can have a look into it once..
</div>


To clarify, If you right click on a Procedure and Choose Modify, then it will create ALTER PROCEDURE statement only and not CREATE PROCEDURE statement. If it comes as CREATE, then you would need to modify that to ALTER to get it work..

Out of curiosity, what is the SSMS version you have as I havne't seen this behavior across any SSMS versions.
Try updating SSMS to the latest version and check once..
Also if possible, share us the procedure which is giving you problems so that we can have a look into it once..

<div>
indeed it asks me for update.. and I ignored it.. maybe I should..<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/06_w25/1342700/My-SSMS-About.png" target="_blank" title="My SSMS About (13 KB)"><img alt="My SSMS About" class="file-block lazyload" style="max-width: 492px;" data-src="https://filedb.experts-exchange.com/incoming/2018/06_w25/1342700/My-SSMS-About.png" /></a>
</div>


indeed it asks me for update.. and I ignored it.. maybe I should..
My SSMS Abouthttps://filedb.experts-exchange.com/incoming/2018/06_w25/1342700/My-SSMS-About.png

My-SSMS-About.png

<div>
<div class="content wysiwyg-content">
Hi,<br />
If I right click on the SP and choose Modify,<br />
edit the code.<br />
click Parse,<br />
and then Execute.<br />
It gives Error:<br />
Msg 2714, Level 16, State 3, Procedure sp_name, Line 2 [Batch Start Line 4]<br />
There is already an object named 'sp_name' in the database.<br />
What am I doing wrong?
</div>
</div>


Hi,
If I right click on the SP and choose Modify,
edit the code.
click Parse,
and then Execute.
It gives Error:
Msg 2714, Level 16, State 3, Procedure sp_name, Line 2 [Batch Start Line 4]
There is already an object named 'sp_name' in the database.
What am I doing wrong?

How do I update a Stored Procedure in Microsoft SQL Server Management Studio

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.