In this article I am publishing a stored procedure I have recently written and which given a database name as an input parameter it returns the below basic information:
The following catalogs are used:
You can download the stored procedure
here.
Feel free to post any comments for adding more functionality to the stored procedure!