Object Explorer

SQL Server 2012 continues to use an integrated Object Explorer that behaves similar to SQL Server 2008. The asynchronous population of the Object Explorer tree continues to be a time-saving feature. This may not hit home for folks who deal with smaller databases, but it can be a real time saver for those who are dealing with many databases on a single SQL Server instance or for those who work with databases that have a significant number of database objects. The Object Explorer tree in SSMS displays immediately and allows navigation in the tree and elsewhere in SSMS while the population of the tree is taking place.

The Object Explorer is adaptive to the type of server it is connected to. For a Database Engine server, the databases ...

Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.