Under Management Studio, when I right-click a stored proc, select Modify, change the stored proc, then select Execute, the stored proc is updated on the server. But then I noticed that the sql tab holding the changed stored proc (in the right pane of Management Studio) still diplays and asterisk (*). When I right-clicked the tab it offeres the Save option but that is to save the sql file (with the * in its tab) to a file. This is confusing behaviour.
Is there any way to change this behaviour so running Execute causes the (*) to disapeear?
TIA,
Barkingdog
The asterisk means the script file you are modifying is not saved to disk. Executing the script/file does not save the file and that is why the asterisk does not disappear.
You have to consider the actual procedure in the database as not being the script/file in management studio that creates/updates it.
Execute does not save the file as it only communicates with the connected server. Save does not update the connected server as it only saves the script to disk.
No comments:
Post a Comment