![Image](https://i.imgur.com/qmWMMAt.png)
https://imgur.com/gQIdzu0
1. I think this is permissions related because this only happens on the production environment where we aren't sysadmins.
2. If my current database context is master or tempdb, it works as expected. Once I change it to certain user databases (ex. EDWDB), even though I am db_owner, the issue appears. A different user database (Marketing) works as expected. Very strange.
3. I have RedGate SQL prompt on a different computer (albeit with a different SSMS version) and the issue does not exist at all, so unless SQL Complete does something differently, it shouldn't be a permissions issue.
The workaround is having USE master at the top of my query, which isn't really a good solution.
To rule out permissions issue, what permissions are needed for this to work correctly? As far as I can tell, this is a bug.
Any ideas?
I'm on SQLComplete 6.3.16 and SSMS 18.4.