Tuesday, February 26, 2013

Object Explorer Details

"Object Explorer" is a very common, friendly pane found under the "View" menu in Microsoft SQL Server Management Studio, however, did you know that the "View" menu also holds "Object Explorer Details" which when opened side-by-side with "Object Explorer" will give you specs on the thing you have selected at "Object Explorer!" For example, click on "Stored Procedures" under "Programmability" under a database at "Object Explorer" to see a list of the stored procedures at "Object Explorer Details" where there will be a column for "Create Date" and also one for "Date Last Modified" (you have to unhide this column) which should help you see what has changed recently.

No comments:

Post a Comment