Is there Microsoft SQL Mangement studio Edit procedure command

I have around 50 databases, all identical structure. Now I have to edit one procedure, so the process is a bit complex:

1. expand database,
2. expand programmabil开发者_如何学编程ity
3. expand stored procedures
4. right click on procedure
5. select modify

What I want to know: Is there a command that will open the modify window for a specific procedure so that my process will just be

1. select database
2. CTRL+E to execute command

When I say command I mean text in editor window, something like this

edit procedure 'my_procedure'

Maybe I misunderstand your question... but...

If you want to use SQL Server Management Studio:

Could you simply copy the ALTER statement, paste it in a new window, change the database that window is connected to, execute, change database, execute, etc.

If you want to do it faster and more repeatable, you could just save the query to a file and write a script in cmd using sqlcmd to run that script on each of your 50 databases.

http://msdn.microsoft.com/en-us/library/ms162773.aspx

I can't imagine managing 50 databases w/ the same structure and not using scripting...