Home Forums SQL Server 7,2000 Performance Tuning Any Catalog view to find objects referred in other database in dynamic query RE: Any Catalog view to find objects referred in other database in dynamic query

  • 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