Tag Info

New answers tagged

1

* Please Read * As noted in @Spörri answer above, sys.sql_dependencies is deprecated. sys.sql_dependencies (Transact-SQL) : This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use ...


2

sp_depends will give you list of dependent objects in all current versions of SQL server but is listed as deprecated. Here is a MSDN article with a way to find objects referencing a function and with small modifications you can get the list of object referenced by a function: SELECT OBJECT_NAME(object_id) AS referencing_object_name ...


1

I had a script that does a rudimentary version of foreign key traversal. I adapted it quickly (see below), and you might be able to use it as a starting point. Given a target table, the script attempts to print the join string for the shortest path (or one of them in the case of ties) for all possible source tables such that single-column foreign keys can ...



Top 50 recent answers are included