harsimranjeetsinghwasson (8/2/2013)
Hi,Is there any catalog view for finding reference objects in other database or same but is written in dynamic query in view/store procedure/function.
I found some like syscomments,sys.all_sql_modules,sys.sql_modules but is there some catalog view like
sys.all_expression_dependencies which does not show objects referred in dynamic queries.
Please Suggest :-).
,Regards
Harsimranjeet Singh
I am not quite sure what you are looking for. Are you looking for references in things like stored procs where the references are in dynamic sql within those procs? Can you please try to clarify what you are looking for?
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/