http://sqlblog.com/blogs/davide_mauri/archive/tags/SQL+Server/2005/Object+Dependencies/default.aspxTags: SQL Server, 2005, Object DependenciesenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlblog.com/blogs/davide_mauri/archive/2010/01/07/sys2-scripts-updated.aspxThu, 07 Jan 2010 20:54:10 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:20694Davide Mauri0http://sqlblog.com/blogs/davide_mauri/comments/20694.aspxhttp://sqlblog.com/blogs/davide_mauri/commentrss.aspx?PostID=20694<p>I’ve updated my “sys2” scripts with three 3 new scripts:</p> <p><strong><em>sys2.objects_dependencies</em></strong> <br />A wrapper around sys.sql_expression_dependencies that shows also related informations taken from sys.object table, like object name, object type and schema name of the referencing entity. </p> <p><strong><em>sys2.objects_partition_ranges</em></strong> <br />Shows information on partitioned table like rows per partition, partition ranges and partition filegroup destination. </p> <p><strong><em>sys2.objects_data_spaces</em></strong> <br />List tables and indexes and show in which filegroup they reside. </p> <p>They are freely available – along with all the others – here:</p> <p><a title="http://www.davidemauri.it/resources/sql-scripts.aspx" href="http://www.davidemauri.it/resources/sql-scripts.aspx">http://www.davidemauri.it/resources/sql-scripts.aspx</a></p> <p>Enjoy!</p><img src="http://sqlblog.com/aggbug.aspx?PostID=20694" width="1" height="1">20052008DMVObject DependenciesPartitioningScriptsSQL Serversys2T-SQL