One useful system stored procedure is sp_helpdb. This stored procedure returns information about all of your databases on your server such as the size, owner, when it was created and the database settings. One issue that you may run into is that the stored procedure does not provide data, but an error occurs instead. The error that you receive is “Cannot insert the value NULL into column ”, table ”; column does not allow nulls. INSERT fails.”

Useful tips to fix this here