How can we help you today? How can we help you today?

Can you stop Code Analysis from preventing the popup so I can get the script for an item?!

Okay, I'll ask here before I simply turn it off, since I see the overall value in the Code analysis feature. But I'm always using SQLPrompt's ability to show the entire script for a table/SP, which is hampered because I'm cutting/pasting from somewhere, so there's a either three-name-DB Call, or I'm not in the right database, or "parameter was not supplied", or whatever, and it won't show the "do you wanna view the script" popup while there's a Code Analysis issue.I just want to see the fscking script. Don't not show it because you're showing me why my code sucks.
mbourgon
0

Comments

2 comments

Sort by
  • Jon_Kirkwood

    Hi @mbourgon

    Can understand some of the frustration there, not sure of all the scenarios you face but I do know that sometimes the pop-up doesn't appear as it can't fully qualify the object you are trying to view.

     The Code Analysis feature is largely an on/off setting without a lot of granularity of the features within it to modify.

     You may be able to change the behavior a bit through the SQL Prompt Command Palette (SQL Prompt > Open Command Palette <ALT+S>

     In the options section you can toggle different settings on or off. This may offer some flexibility in allowing you to copy in code and still have some pop-ups appear as you want.

     


    Alternatively, your request may be a UserVoice functionality request to be implemented into SQL Prompt in the future. You can put a feature request for SQL Prompt here https://redgate.uservoice.com/forums/94413-sql-prompt/ 
    Our development and product teams review UserVoice to help shape the future direction that our tools take and can be a valid way to get new features and functionality added.


    Jon_Kirkwood
    0
  • mbourgon2
    @Jon_Kirkwood thanks. The problem isn't that, though.  See below - when there's no "bad code", it'll show the tooltip so that I can view the object, but not when there's bad code (as per the rules). 

    no tooltip from sqlprompt.


    make it so that the code sniff isn't valid, and ....

    mbourgon2
    0

Add comment

Please sign in to leave a comment.