Object Explorer Details and Search in SQL Server 2008
Posted by decipherinfosys on October 7, 2008
We have been covering SQL Server 2008 features right from the CTP stages. You can search for those on our blog site and also see the collection of those posts (till April 2008) from the whitepapers section. Object Explorer has some more enhancements in SQL Server 2008 that are worth mentioning.
Let’s open up SSMS and if you do not see the Object Explorer Details windows, then press F7 or from the menu, you can select View/Object Explorer Details and you will see the details section like the one shown below:
As you can see, you will be able to see the Policy Health State, Recovery Model, Compatibility Level, Collation and the database owner information in the details section. These are the ones that are available to you by default – in order to add or remove from the pane, you can right click on any of them and then select more columns:
And all the changes that you make are preserved so when you log out and log back in, those will still be present. The details section also has a search functionality for searching on the objects. Nothing rocket science about it, but one thing to look out for is that if you want search across all the databases, you need to select the “Databases” object in the Object Explorer on the left hand side. Searching has become a lot more easier now from the GUI itself and can be done for objects in a database or across databases on the instance.