How to Differentiate System and User Databases In SQL Server?

 

This question is frequently asked in many forums and the most popular answer is to use the DB_ID() function which is not exactly correct. This FAQ shows how you can do that perfectly.