Yes, i need the detail of objects referred from other database in a database
for example : departmentdw database has some procedure that refer amazon database objects like tables
USe departmentdw
create proc a
as
begin
exec 'select * from Amazom.dbo.people'
end
i want to find these database references which are mentioned in dynamic query. I can used other catalogs views
like syscomments and all writter in my question by i like to know some catalog view like sys.all_expression_dependencies which i found out doesn't show database object referred in dynamic queries