Options
Bug: Ctrl+F12 expands System SPs, no-show for requested SP
PDinCA
Posts: 642 Silver 1
Version 7.2.2.273 in SSMS of June 2016.
No sign of the SP highlighted.
This appears to be a bug.
The question is, "should SQL Prompt clear the Filter for that type, or inform the User of the presence of the Filter and offer to either 1) clear, or 2) script the requested object (where possible)?" I'd happily have it clear the current filter as Ctrl+F12 is more powerful, IMO.
-
Expand Object Explorer to Stored Procedures and type in a narrow filter - explicit full name of an SP will suffice.
Right-click and Modify, which opens a T-SQL Query script window on the same DB.
Place the cursor over the name of an SP the scripted SP executes.
Hit Ctrl+F12
All
No sign of the SP highlighted.
This appears to be a bug.
The question is, "should SQL Prompt clear the Filter for that type, or inform the User of the presence of the Filter and offer to either 1) clear, or 2) script the requested object (where possible)?" I'd happily have it clear the current filter as Ctrl+F12 is more powerful, IMO.
Jesus Christ: Lunatic, liar or Lord?
Decide wisely...
Decide wisely...
Comments
Clearing out the filter sounds reasonable to me if the object can't be found with the filter enabled. We're currently working on the Ctrl+F12 functionality to fix another issue so hopefully we can fix both at the same time.
Thanks,
Aaron.
Sorry for the delay with this - it turned out that removing the filter in the object explorer was a little more work than we'd hoped but the functionality should now be in the latest release of SQL Prompt (7.2.4 - from either check for updates or our website)
Please let me know if you have any issues with it.
Thanks,
Aaron.
Decide wisely...