Hi,
This might turn out to be dumb question of the day, but I am struggling to find a workflow in Visual Studio when editing stored procedures. If I want to edit a stored procedure, I can right-click it in the Server Explorer and make my edits no problem. However, when I press CTRL-S to save it again, the dialog goes to a library location I don't recognise and changes the name of the stored procedure file to something of the form dbo.MyStoredProcedure.sql. I can easily navigate to a different folder and change the name, but it doesn't remember my changes, so I have to do this every time, which is useless.
I am obviously not working with stored procedures in the way they are supposed to be worked with. Can anyone offer any advice, please?
Kind wishes ~ Patrick
Submit an article or tip