Below you will find the code to return several database settings for each database. Simply select the text and copy to the Clipboard.
SELECT CONVERT(VARCHAR(100),Name) AS ‘Name’
This code was written using the Microsoft SQL Server documentation. If you find that this code was copied from else where, please let me know so I can give proper credit.