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

EXEC sp_rename OLDNAME, NEWNAME

This is assuming you can execute SQL statements via VS2008.

Answer 2

If you have SSMS, you can right-click on the procedure name and choose rename.

The other option is to drop the procedure and recreate it with the new name.