maravig - Wednesday, October 18, 2017 6:29 AM
We would have no way of knowing if a view changed or what views contain what columns or where a certain view may be.
If you can't see something, there is a possibility you don't have permissions.
One thing you can try is to search the database for whatever column names you are trying to find. If you search on sys.columns, it has columns for both tables and views. You could search using something like: USE YourDatabaseName
GO
SELECT
schema_name(o.schema_id) as SchemaName ,
object_name(c.object_id) as TableOrView,
c.[name] as ColumnName,
o.modify_date
FROM sys.columns c
INNER JOIN sys.objects o
ON c.object_id = o.object_id
WHERE c.name LIKE '%ColumnNameToFind%'
Sue