Change name of stored procedure in SQL Server 2008

Question

I have a stored procedure which I edit through Visual Studio 2008. Is there a simple way to change the name of the stored procedure? Right now if I look at the sproc's properties, the name of the sproc is grayed out.

Answer 1

if you have management studio you can right click on procedure name and choose rename .

otherwise you have to drop and recreate;

Answer 2

EXEC sp_rename OLDNAME, NEWNAME

Assuming you can execute SQL statements via VS2008. I mostly use SSMS for my SQL work.