New features added to SQL Prompt Watch now.

Change of functionality?

Hi
We have a lot of cross database procedure calls and as such many are defined as database.schema.procedure. Prior to version 9 you would still get a code window when hovering, now you don't. What I now get is a pop saying "Reference to procedure in other database".. even if I am in that database
Can we revert back to the old better functionality? I cant find an Options setting to do this
Thanks

Answers

  • FabiolaBFabiolaB Posts: 54 Silver 3
    Hi @wonderbison ,

    Sorry to hear that you are having this issue.
    Yes, you can disable this rule, there are 2 ways to do it.

    The first one:
    - Click on the text that is underlined in green. A blue light bulb should appear on the left side of your editor.
    - Click the light bulb. The issue details window will appear.
    - Click on 'Disable rule'.

    The second way:
    - Go to SQL Prompt menu and click on "Manage Code Analysis Rules..." (4th option from the top). The Code Analysis rules window appears.
    - Uncheck rule EI016 : Reference to procedure in other database.
    - Click 'Save'.

    The code window you are looking for should appear again.
    I hope this helps,
    Regards,
    Fabiola
  • I guess it would be perfect if you can see the code violation but still / additional the reference / suggestion.

    Currently the code analysis seems to have priority...

    Torsten
Sign In or Register to comment.