Okay. So I'm breaking some new ground and trying to get into Azure Data Studio. I'm having a problem with intellisense that seems to be a bug with Azure Data Studio but I'm not sure. I have issues with basic queries. Foreign keys, select statements and insert statements are all telling me in this example that chocolate_category does not exist, it says it is an invalid object name, or that the foreign key is invalid because the table name is invalid, etcetera. Simply put ADS is erroring on tables that do in fact exist. In this case, I was able to insert data even though the intellisense thinks the table name is invalid. Then I was able to select from the table. Why is this happening and how can I fix this? Control-Shift-R does not work to refresh intellisense. Adding dbo. prefix to the table name does not work either. As you can clearly see in this image, the table exists within the database that I'm located. The query shows an error, however running it puts up a result. If my code works on the table name, then why the error? I have found that it is possible to continue through this error, but it is very annoying to me to be told something is broken that is not broken.

I am using SSMS 2016 (ver: 13.0.15000.23) and connecting to SQL Server database 2016 (ver: 13.0.5081.1). IntelliSense is not working on my SSMS. I tried the following: - Tools >> Options >> Text Editor >> Transact-SQL >> IntelliSense, and select Enable IntelliSense - Tools >> Options >> Text Editor >> Transact-SQL >> General, and verify Auto list members and Parameter information check boxes are checked - Query >> IntelliSense Enabled - Verify that SQLCMD is disabled - Refreshed IntelliSense cache (Ctrl+Shift+R) - Making sure no compile errors are in the query - Uninstall and reinstall SSMS I asked other members in my team and IntelliSense only works sporadically for them, if it does. Question: Is there a server setting which is disabling IntelliSense on SSMS? I've already gone through all of these questions: - IntelliSense not working but it is enabled - IntelliSense is not working at SQL Server Management Studio - Why is SQL Server 2008 Management Studio Intellisense not working? - SQL Server Intellisense not working on some servers - SQL Server 2008 R2 intellisense doesn't work - SSMS IntelliSense doesn't work on particular database I have limited permissions on the instance, but I can select and update records in the database I'm working in (I didn't try insert). I can see around 1,600 names of objects and columns by running: ``` SELECT o.name, c.name FROM sys.objects o INNER JOIN sys.columns c ON o.object_id = c.object_id WHERE o.is_ms_shipped = 0; ```

I have literally installed on my development machine three different versions of SSMS standalone: 2008, 2012, 2014, and I work with SQL Server 2008 databases. On every single one of those versions, I tried to have IntelliSense display my available columns when I type a table alias and a dot "Table." for example. But that doesn't show up over 90% of the time. This happens similarly on any SSMS version I try. I've searched for other people having this issue and found various cases, but none of those provided solutions, such as refreshing the IntelliSense cache and disabling/re-enabling IntelliSense itself, de-selecting e re-selecting certain options, work for me. Could this be a problem related to the instances of SQL Server that I am connecting to, rather than with SSMS itself? Edit: I have also tried to install a third party addon to SSMS, it then starts displaying as expected, but cripples my performance (making typing somewhat slower as it loads things in the background, which I really don't like), so I would rather fix the original functionality instead of resorting to that. Thanks

I would like to navigate to open a directory path from an in-line commented UNC path. SSMS integrates with Windows Explorer and Explorer allows UNC navigation from the address bar. Indeed, when in the integrated browser, it is possible to navigate among UNC paths. HOWEVER, the click-thru functionality provided for `http:/` prefaced URLs in the text editor of SSMS does not seem to exist for UNC paths. The Web Browser section of Options / Environment appears to open Internet Explorer options and the Text Editor / Plain Text / General section has the "Enable single-click URL navigation option", but does not appear to allow definition of what is detected as a URL. Screenshots linked below (added sample code below) ``` use [master] go -- http://www.google.com -- \\servername\unc\BackupFolder\ select 'This query needs to be uploaded to the URL' Header union select 'and also saved for archiving at the UNC path' union select 'so is it possible to clickthrough to both?' ```

I have SSMS 2014 installed on my desktop, and many 2012 and 2014 databases running in our data center. So far I found one database (database A) doesn't have IntelliSense working, for exampletyping: ``` SELECT [put cursor here] FROM sys.objects ``` and moving cursor between select and from, pressing CTRL + J, I can see popup options for other databases, just not for database A. I have checked all options and refresh local cache, all don't work, and I am using an account which has sysadmin permission. - The compatibility level is 11.0 - Version is Microsoft SQL Server 2012 - 11.0.5556.0 (X64) Oct 31 2014 16:50:24 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.3 (Build 9600: ) I can log on to the db server which is in US and see IntelliSense working there, it just doesn't on my desktop (in Australia). Is it most likely a latency issue? is there a timeout limit or setting for this feature?

IntelliSense in SSMS isn't updating unless I shut it down and restart. I've tried disconnecting from the server and reconnecting while the SSMS session is active, but that isn't working. Steps to recreate: - Create a table - Select something from that table - SSMS displays squiggly red lines under it with the tip "invalid object name" - Execute the query How can I force IntelliSense to update without restarting SSMS?

This problem is really proving to be a tricky one (and quite annoying). In SQL Server Management Studio 2008, up until a few days ago my IntelliSense was working great. Then all of a sudden it stopped. The icon as it as enabled on the toolbar menu, and under Tools -> Options -> Text Editor -> T-SQL -> IntelliSense it says it is enabled there. I have tried refeshing the IntelliSense cache with Ctrl-Shft-R but that doesn't work either. Any ideas what happened to my IntelliSense and what I need to do to get it back?

I'm working off an SQL 2008 instance that sits on our intranet. All is fine except that sometimes intellisense is there and working and sometimes it isn't. Its a pretty fast network so I don't imagine its a case that the RDBMS is reactively switching intellisense off because of latency issues etc. Is there some other mechanism that can be used to ensure that intellisense always works?

Latest version of Management Studio (i.e. the one that ships with SQL Server 2008) finally has a Transact-SQL IntelliSense feature. However, out-of-the-box it only works with SQL Server 2008 instances. Is there some workaround for this? [I asked this question a while ago at StackOverflow and unfortunately nobody knew such a trick. Maybe I will have more luck with this problem here.]

Developers get no autocomplete, class sorting, or hover documentation for Tailwind classes in their editor. They have to memorize the full utility API or constantly reference docs.