I'm having issues saving queries that were not made by me so I can edit the results. When I do so and try to add the query to my favorites page, nothing happens. "Save As" a query made by a coworker that has marked it as not editable.
We are currently evaluating this issue and will update this article when we have more information.
In the meantime:
Open the query that has been Saved as your own Go to Tools>Query Options Check the option that Other Users may Modify this Query Click OK Click Save on the Query Now click Favorites>Add to Favorites and the options to Add to Favorites will appear.
Steps to Duplicate
Create a Query and Uncheck option "Other users may modify this query"
Open the query logged in as another user that is a member of a security group
Run the query and Save it as your own
Click Favorites in the top Navigation bar and Select Add to Favorites, but additional options for Favorites do not appear and it does not add.
No specific environment issues due to Duplicating on 7.95 stand alone with SQL Express