OK,<BR> Here's a SQL Server version of that query, keep in mind that it _will_ return multiple resultsets each with a table name prepended to the other columns.

I know in Oracle you can use DBA_TAB_COLUMNS (or ALL_TAB_COLUMNS). My SQL Server knowledge is very rusty, but can't you use the INFORMATION_SCHEMA.COLUMNS view ...