I have a ton of stored procedures that I developed when we had SQL Server 2000.

Today, I had to make a change to one of them. We are now running SQL Server 2008 and I'm using Management Studio, not Enterprise Manager.

In Management Studio, I right clicked on the stored procedure, clicked "Modify", and a whole bunch of changes, but it doesn't want to let me save them back to the stored procedure. It wants to save what I did to a disk file as SQLQuery1.sql

How do simply resave the stored procedure?