>>MS doesn't guarante that structure of the system tables wouldn't change in the future. Here's the query that uses information schema which conforms to the SQL-92 Standard.

SELECT * From INFORMATION_SCHEMA.TABLES
>>	WHERE table_type = 'BASE TABLE'
>>		AND table_name <> 'dtproperties'

>
>Sergey,
>
>Thanks for the info - where would I look to find more information on "INFORMATION_SCHEMA"?

See Information Schema Views in BOL.

>I'd like to do a similiar query to get the names of all the databases on a SQL Server with the exception of the system databases (i.e. master, model, etc.)


You can use
- SELECT * FROM INFORMATION_SCHEMA.SCHEMATA
- system SP sp_helpdb.