This dialog is launched when user choose File | Open and specifies a .sql to load. Dialog behavior:
When a user expands a server, don't show information about the server. Instead, show a similar tree like structure as we display in our schema tree. Only DB names and Schemas needs to be showed. No other objects.
Once user has chosen a server or DB, and clicked "Open in Query Analyzer", then load the file in a new query analyzer window
Ensure that any connections that were opened due to browsing various schemas / Dbs are closed once this dialog is closed.
Kin-Hong, I dont think that the connection that was opened during browsing is closed.
I did a simple test with SQL Server. I executed the below query in SQL 2008 and found the number of processes. Then used File->Open and then connected to the same SQL 2008 and opened in text editor. I could see the count of processes increment by 1, which seems to reflect that on connection and browsing the database, 1 connection was established but when that dialog was closed, connection was not closed
SELECT spid, hostname, loginame, status FROM master.dbo.sysprocesses
Connections were only closed when the user clicked "Open in Query Analyzer". Now connections are closed when the dialog is closed.
Connections were only closed when the user clicked "Open in Query Analyzer". Now connections are closed when the dialog is closed.
Issue #8615 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build 14.0.0.rc-7 |
No time estimate |
1 issue link |
breaks #9891
Issue #9891Drop down does not display the selected database for Query Analyzer Window. |
Kin-Hong, I dont think that the connection that was opened during browsing is closed.
I did a simple test with SQL Server. I executed the below query in SQL 2008 and found the number of processes. Then used File->Open and then connected to the same SQL 2008 and opened in text editor. I could see the count of processes increment by 1, which seems to reflect that on connection and browsing the database, 1 connection was established but when that dialog was closed, connection was not closed
SELECT spid, hostname, loginame, status FROM master.dbo.sysprocesses