If I type "USE AdventureWorks", for example, there's a hyperlink on the word AdventureWorks. All it really tells me is that it's a database on the server I'm connected to, which isn't terribly useful.
It would, however, be very useful to display metadata about the database. For example, logical and physical file names, recovery model, database compatibility level, size, space available, etc. Basically some amount of the information shown on the General, Files and Options tabs in the SSMS Database Properties window.
I imagine the limitation is that permissions may prevent some users from reading the system tables for this information, but I would think you could test for that and provide the current display to non-privileged users. As a DBA, this would be a great enhancement to the tool that would save me time on a regular basis.
Thanks for your consideration.
Hi there,
It would, however, be very useful to display metadata about the database. For example, logical and physical file names, recovery model, database compatibility level, size, space available, etc. Basically some amount of the information shown on the General, Files and Options tabs in the SSMS Database Properties window.
I imagine the limitation is that permissions may prevent some users from reading the system tables for this information, but I would think you could test for that and provide the current display to non-privileged users. As a DBA, this would be a great enhancement to the tool that would save me time on a regular basis.
Thanks for your consideration.