i have the following query that worked just fine on CF7 and SQL server 2000

<cfquery name="getColumns" datasource="ds">

SELECT Column_Name, Data_Type

FROM INFORMATION_SCHEMA.Columns

WHERE Table_Name = 'Fields'

AND Table_Catalog = 'databasename'

</cfquery>

now that have upgraded to CF 9 and SQL 2012 - this query does not work

"

Any ideas - trying to export from SQL database to an excel file - THANKS!