Different settings for SSMS and SSDT possible?
TomL
Posts: 13 Bronze 2
in SQL Prompt
Hi,
I'm using both SSMS and SSDT side by side.
Unfortunately, SQL Prompt is not fully implemented in SSDT. You always need an active connection to get the intellisense working properly. (see https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/5985591-load-suggestions-from-sql-files-in-visual-studio-s )
As a workaround, I'm using the integrated intellisense, which is just 'fine'.
To make this work, I need to disable 'Automatically show suggestions after 0 milliseconds' under 'Show code suggestions'.
Unfortunately, this also disables it in SSMS. So I'm always turning 'Enable Suggestions' on and off, when switching between the programs.
I would like to have it enabled in SSMS, but disabled in SSDT.
Is this possible? It seems that both share the same config.
Best regards,
Tom
I'm using both SSMS and SSDT side by side.
Unfortunately, SQL Prompt is not fully implemented in SSDT. You always need an active connection to get the intellisense working properly. (see https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/5985591-load-suggestions-from-sql-files-in-visual-studio-s )
As a workaround, I'm using the integrated intellisense, which is just 'fine'.
To make this work, I need to disable 'Automatically show suggestions after 0 milliseconds' under 'Show code suggestions'.
Unfortunately, this also disables it in SSMS. So I'm always turning 'Enable Suggestions' on and off, when switching between the programs.
I would like to have it enabled in SSMS, but disabled in SSDT.
Is this possible? It seems that both share the same config.
Best regards,
Tom
Tagged:
Best Answer
-
Russell D Posts: 1,324 Diamond 5Hi @TomL unfortunately there isn't a way around this at present but we are actively looking into team based development options, and the shared config will form part of that work. No ETA yet but we are working on it.
Have you visited our Help Centre?
Answers
it is not the answer I wanted to hear, but I have to accept it
Thank you for the quick response.