Change of functionality?

wonderbison

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

FabiolaB

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

torsten.strauss

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