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

BUG: SQL Prompt is not properly working in SSMS that runs under different domain account

If you will use SSMS under different account and start SSMS via:

@echo off
runas /user:domainA\user /netonly "c:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe"

and you are actually working on your PC in domainB, your SQL Prompt will lag like:
- not properly refreshing meta data of the table, or DB object will  not appear at all in suggestions;
- doesn't highlight syntax;
- refresh suggestion doesn't work;
- cross DB queries are not highlighted/suggested;

The are two way to make it working:
1) Execute User [Database]; GO; in each window or each execution block;
2) Then run refresh suggestion.

This bug is valid for all edition during last 3 years. I'm just tired of this.
yevheniy.martynenko
0

Comments

4 comments

Sort by
  • meastland75
    Agree...would be nice to see this fixed.
    meastland75
    0
  • nenkie76
    Any fix or should we escalate via sales department, so you start moving?
    nenkie76
    0
  • meastland75
    nenkie76 - I was able to get this to work by logging on to the same machine using the account identified in the runas command and configuring the SQL Prompt environment.  After that, SQL Prompt worked as expected with ssms via runas.
    meastland75
    0
  • nenkie76
    Good that you have access to that domain via RDP and extra license, but we don't.
    nenkie76
    0

Add comment

Please sign in to leave a comment.