Agreed - however if the tables have a lot of fields instead, the where clause will be long and tedious to maintain.

The FULL OUTER JOIN method shown in the article has one major flaw compared to the EXCEPT method - identical rows are not excluded from the result set. With the...

Although some questions very well could be written without sample code I think it is generally a...

Thanks for the replies - using the database_id seems to be a solid workaround (even though it still puzzles me that there is no regular field to display system vs....

I would like to fire up a T-SQL query that gave me more or less the output I get from "select * from sys.databases" - but without the system databases....