Received a demand, there is a group of people, just want to give them read permissions, both of them are in the Windows domain controller, they use a domain user login database, so the k3c \ support the domain login name of sysadmin permissions remove, and then in the instance specific db_datareader permissions to realize library to business needs, but very strange flower query auto-completion problem, don't know about what,,

SQL SERVER 2014, if is the operating system (Windows) authentication logon domain user group, SERVER role is not to the domain users group sysadmin permissions, query table name cannot be automatically when the completion table name,

Tested to the sysadmin permissions can select automatically fill full name of the table, not to give not

If it is to build a user name, use the user name login to SQL SERVER authentication, do not give the sysadmin permissions, select and will automatically prompt, but change with the operating system domain login user group (Windows authentication), was no,

Should not pass SSMS, tools - options - text editor - Transact - SQL - IntellSense has enabled,

Help!!!!!!