Hi
I have a stored procedure that I have deployed with a database to an sqlserver. To access the database and the stored procedure I am now using SQL Server Management Studio Express. When I was amending the stored procedure locally, I simply "opened" it, made the amendments and then "saved" it. With S.M.S.E. if you click on "modify" a SQLQuery opens up and then after making the amendments you can save the SQLQuery. How do you go from here to effect that change to the stored procedure resident on the sqlserver.
Chris
I've worked out that all I have to do is run the query after amending the stored procedure detail.
Chris
|||
When you click the Modify button, it should show you the stored procedure and it will have an ALTER PROCEDURE command at the top. This just tells the database that you want to overwrite the existing stored procedure with whatever text follows. So, if you click the Execute button (it should have an exclamation mark next to it) the command should execute against the database and your stored procedure will be updated.
Mark
Thanks for your reply
Chris
No comments:
Post a Comment