There's an excellent blog by Kalen Delaney on this subject :- http://sqlblog.com/blogs/kalen_delaney/archive/2007/09/13/geek-city-the-resource-database.aspx

I think her query from sysdbreg table does still show some ambiguity in the database name though 🙂