Q:

How can I return the database column name in the results grid when using SQL Server 2008 R2?

I have a query that returns all the columns from a several tables in a table however would like to identify which column names belong to which table. Is there a way I could have these return on the results grid?

A:

Can't you just use:
SELECT  *
FROM    INFORMATION_SCHEMA.COLUMNS

That should give you the following:
TABLE_CATALOG ,
        TABLE_SCHEMA ,
        TABLE_NAME ,
        COLUMN_NAME ,
        ORDINAL_POSITION ,
        COLUMN_DEFAULT ,
        IS_NULLABLE ,
        DATA_TYPE ,
        CHARACTER_MAXIMUM_LENGTH ,
        CHARACTER_OCTET_LENGTH ,
        NUMERIC_PRECISION ,
        NUMERIC_PRECISION_RADIX ,
        NUMERIC_SCALE ,
        DATETIME_PRECISION ,
        CHARACTER_SET_CATALOG ,
        CHARACTER_SET_SCHEMA ,
        CHARACTER_SET_NAME ,
        COLLATION_CATALOG ,
        COLLATION_SCHEMA ,
        COLLATION_NAME ,
        DOMAIN_CATALOG ,
        DOMAIN_SCHEMA ,
        DOMAIN_NAME

