Intellisense on multiple azure DB's

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
Zenuka
Posts: 3
Joined: Tue 25 Mar 2014 07:25

Intellisense on multiple azure DB's

Post by Zenuka » Tue 25 Mar 2014 07:32

We have multiple SQL Azure databases on the same server. When I first start a query on DatabaseA intellisense is working nicely but when creating a new query on DatabaseB the intellisense will only give a suggestion for DatabaseA. I used to do a ctrl+shift+r but that stopt working a couple of versions ago (and doesn't seem to do anything anymore). The only way to have intellisense back is opening a new SQL server management studio. Any suggestions?
P.s. I've updated today to 4.5.188.1 but no luck...

alexa

Re: Intellisense on multiple azure DB's

Post by alexa » Tue 25 Mar 2014 10:58

Could you please let us know in what way you are changing a database? Screenshots will be also of help.

You can send a reply straight to our support system at supportATdevartDOTcom, so we will keep further correspondence with you on this issue via e-mail.

Zenuka
Posts: 3
Joined: Tue 25 Mar 2014 07:25

Re: Intellisense on multiple azure DB's

Post by Zenuka » Wed 26 Mar 2014 07:22

I'm not changing the database...
Steps to reproduce:
- Open SQL Server Management Studio
- Right click an azure cloud database (for example 'DatabaseA') and select new query
- See that intellisense is working: SELECT * FROM ...
- Right click another azure cloud database (for example: 'DatabaseB') on the same server and select new query
- Intellisense stopped working; typing 'SELECT * FROM ' (Ctrl+Space) doesn't give me any suggestions other then DatabaseA.
I hope this is enough information because I don't see an option to upload images.

Edit: I didn't read the last line, will drop some screenshots in the e-mail

alexa

Re: Intellisense on multiple azure DB's

Post by alexa » Tue 27 May 2014 11:33

We would like to let you know that we have released dbForge SQL Complete, v.4.7 Beta where the issue you reported is fixed http://www.devart.com/dbforge/sql/sqlco ... nload.html

Thank you for your help in improving dbForge SQL Complete.

Zenuka
Posts: 3
Joined: Tue 25 Mar 2014 07:25

Re: Intellisense on multiple azure DB's

Post by Zenuka » Tue 03 Jun 2014 15:58

The issue is indeed fixed in the new beta version. Thanks!

alexa

Re: Intellisense on multiple azure DB's

Post by alexa » Wed 04 Jun 2014 10:44

Please let us know if any questions arise.

Post Reply