I'm modeling a database for SQL Server 2005 and am trying to produce a simple report that will list the basic information which I am able to do using the TableView template report.
However, I have tables with the same name appearing in different schema's, is it possible to produce a report that shows both the schema and table name. Schema.Table?