SQL Server 2008 Management Studio Trick
January 22, 2009 at 12:57 pm (SQL Server 2008, SQLServerPedia Syndication, Tools) (management studio, SQL Server Management Studio, trick)
I just had a Tremors moment. “Everybody knows about ’em Earl, we just never told you.” Except that no one I showed it to has ever seen it before. So maybe this is something a little new.
I had a database selected in the Object Explorer window and I had the Object Explorer Details window open. I noticed a little icon at the bottom of the screen:
Then I saw that the bar above it was a moveable bar. So I moved it and saw this:
Whoa! So then I tried a table, HumanResources.Department from AdventureWorks2008:
Which caused me to check a procedure:
Each line has a little icon on the side that lets you copy it, line by line. It’s really just a way to display the basic properties about the object in a readily accessible format. It’s not going to change my life, or yours, but it sure is handy to know a quick way to access some basic information.