We need to find or build a solution to document our Reporting Services reports. One question that will get asked is "Give me a list of all of our reports that use this column from this table." Originally, we thought that we could just build a metadata database solution that report writer will use to list the object dependencies used in the report (stored procedure, view, table). If we know a column is going to change then we can find all the views and stored procedures that the table is used in and then find the reports. However, that column may not be used in all the reports that use that table. So, we need to document to the actual table column level. Is there any built-in metadata intelligence in SQL Server that we can use? Otherwise, it will be quite cumbersome for the report writer to enter all that information to document each report.
Thanks!