This should probably be really easy but I cannot find the right
combination of SQL statements (pref. SQL-92 compliant) to return me a
list of databases from a SQL Server installation with a column that
signifies whether the database is a system database or not.

SELECT catalog_name
FROM information_schema.schemata
WHERE catalog_name NOT IN ('master','tempdb','model','msdb')

--
David Portas
SQL Server MVP
--

SELECT catalog_name
FROM information_schema.schemata
WHERE catalog_name NOT IN ('master','tempdb','model','msdb')

The info schema views are specified by ANSI but since ANSI SQL doesn't even
recognise the concept of a "database", let alone a *system* database I think
this is the best you can do.

--
David Portas
SQL Server MVP
--

Thanks for your expeditious response. Have a great weekend.

- Bob

*** Sent via Developersdex http://www.developersdex.com ***

Thanks. You too!

--
David Portas
SQL Server MVP
--

[quoted text, click to view]