Store Procedure - How to save the update in SQL 2005 Express??

Hi! I'm using the SQL 2005 Express to connect to the SQL Server 2000. There I found a stored-procedure of what I'm looking for, use the "MODIFY" command via right-mouse click, made some update to it and save it. But it save the SQL file to a "My Document" folder. It doesn't update the SQL Server 2000's stored-procedure file.

So, how do I update it from the SQL Server 2000?

Thanks...

When you click "modify" it will write the ALTER PROCEDURE statement for you. Once you've made the changes to the current sql code, all you need to do is execute it.

Have you made sure that the ASPNet user account has write permissions to the database file? By default it probably only has read/execute. WIthout write permissions it can't update the database file.

Sorry for bumping old thread! The Edit button is not available, so I can't update it at all. Neither is the closed button. It is way past due to closed this old thread. By updating this forum, it is my best interest to help other newbies out there who may be in this situation.

The "save it" method for saving the updated stored-procedure script can't be done with the whatever save button in MS-SQL 2005. I only need to click the "Execute" button to save the altered stored-procedure. I didn't know how to use SQL 2005 Management Studio back then so I didn't know what to look for back then (2 years ago).