Viewing 2 posts - 1 through 2 (of 2 total)
OK, i solved my problem:
USE YOUR_DB
GO
SELECT
OBJECT_NAME(referencing_id) AS CHECKED_PROCEDURE,
referenced_entity_name AS DEPENDENT_TABLE
FROM
sys.sql_expression_dependencies as ed
WHERE
is_ambiguous...
August 28, 2014 at 8:06 am
#1741654
Hi Lowell,
i wrote very similliar procedure as yours in my work to check procedures. My procedure throws RAISERROR when alter can't be done. It helps when it's missing column in...
August 28, 2014 at 2:43 am
#1741575