Following script gives you all user database users, that do not have a server login mapped or where database user name does not match server
Running DBCC CHECKDB you are getting following error message: Check Catalog Msg 3853, State 1: Attribute (referenced_object_id=194099732,key_index_id=7) of row (object_id=2040565179) in sys.foreign_keys does not have
How to calculate database growth over 12 months?
EPM is great tool that builds on top of the SQL Server Policy Mangement and Central Management Server to provide you overview of your enviornment.
Microsoft released Central Management Server (CMS) with SQL Server 2008; it allowed us to have great functionality for multi-server management. However keeping that list up-to-date