T-SQL – Finding Database and their Status Information
sp_help is a very handy system stored procedure to get database and their status level information for SQL Server. Following is the simple syntax to use it:
The output of sys.databases gives very similar information to sp_helpdb, but sp_helpdb is much more compact and easier to read.
Use below script to get information using sys.databases