does the 'FROM' clause exist anywhere in Reporting Services meta data tables? the data governance committee wants to see the server name, database name and table name of all the data sources as a footer on SSRS reports. we were going to try to extract the clauses using full text search NEAR the FROM clause out out of information_schema.routines, but then i thought it may be easier or more reliably had elsewhere.

thanks for your help

drew