Home Dashboard Directory Help
Search

Database list not populating when changing server connection in SSMS by ChrisStewart999999999


Status: 

Closed
 as External Help for as External


6
0
Sign in
to vote
Type: Bug
ID: 773605
Opened: 12/5/2012 3:37:12 PM
Access Restriction: Public
0
Workaround(s)
view
1
User(s) can reproduce this bug

Description

When changing the connection of an open query the database list (ALT+D or CTRL+U) is not automatically refreshed with the databases of the new connection. If you attempt to change the database via keyboard the list still contains the databases from the prior connection. It only refreshes the list if you click on the dropdown arrow.
Details
Sign in to post a comment.
Posted by Microsoft on 4/1/2013 at 3:54 PM
Hello Chris,

Closing this as external issue in Dev10 VS Shell. An internal ticket has been opened to get this fixed but we're unable to get this fixed on the SSMS side.

Until the issue has been resolved though you can type in the full name of the database and press enter as a workaround to change Database contexts.

Two things to note about that though : One is that because of the VS Shell issue the auto-complete will still fill in the old DB names. The second is that there is currently an issue where the DB name was case-sensitive (not matching the case of the DB exactly resulted in an error). This issue has been fixed though and will be available in an upcoming release of SQL Server.

Thanks,
Charles Gagnon (chgagnon@microsoft.com)
Posted by Microsoft on 2/21/2013 at 9:49 AM
Hello Chris. Thank you for bringing this to our attention. We really do appreciate the feedback. We’ll investigate and get back to you. -Walter A Jokiel, Program Manager, SQL Server (wajokiel@microsoft.com)
Sign in to post a workaround.