Microsoft KB Archive/275219

= INF: Object Browser Makes a Separate Connection to SQL Server 2000 =

Article ID: 275219

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q275219



SUMMARY
The Object Browser is a new Microsoft SQL Server 2000 tool that you can only invoke through the SQL Server Query Analyzer (QA). However, the Object Browser makes a separate connection from Query Analyzer (QA) and that fact may sometimes cause confusion as to why a connection to the server exists when all the clients have disconnected.



MORE INFORMATION
The Object Browser in Microsoft SQL Server 2000 is invoked through the SQL Server Query Analyzer. You can use the Object Browser to navigate the database objects of the selected database server. You can create, manage objects, use templates and examine commonly used objects and functions. You can open and close the Object Browser within QA, by clicking Tools, clicking Object Browser, and then clicking Show/Hide. Alternately, you can press F8.

It may be helpful to know that the Object Browser makes separate connections to SQL Server despite the fact that it is opened within Query Analyzer. The Object Browser connects with the same login as the Query Analyzer connection. You can see the login used to connect in the top drop-down box, right next to the server name. The Object Browser can make multiple connections. For example, you can navigate to a table, right-click the table, and then click Open. This opens one connection to SQL Server. Then, you can open another table which establishes an additional user connection.

You may run into situations wondering from where the &quot;mysterious&quot; connections are coming and why you cannot do things like dropping a login or detaching a database while all the connections are seemingly closed.

For example an attempt to drop a login from Enterprise Manager, while the Object Browser is connected but SQL Server Query Analyzer is disconnected, fails with the following error message:

Error 15174: Could not drop login 'login1' as the user is currently logged in.

Attempting to detach a database while the Object Browser is connected causes the following error message to occur:

Server: Msg 3701, Level 16, State 1, Line 0 Cannot detach the database 'pubs' because it is currently in use.