find_synomym_dependencies.sql

SET NOCOUNT ON

DECLARE @tmp TABLE
(
	Id int identity(1,1),
	Name nvarchar(255)
)	

INSERT INTO @tmp
SELECT Name
FROM sys.objects
WHERE type = 'SN'

DECLARE @x int
DECLARE @xMax int
DECLARE @syn varchar(255)

SET @x = 1
SELECT @xMax = MAX(Id) FROM @tmp

WHILE @x < @xMax
BEGIN

	SELECT @syn = Name From @tmp WHERE Id = @x

	PRINT @syn
	PRINT '==='

	SELECT Name
	FROM sys.procedures
	WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%' + @syn + '%'

	SET @x = @x + 1
END

SET NOCOUNT OFF