http://sqlblog.com/search/SearchResults.aspx?o=DateDescending&tag=T-SQL,2005,Object+Dependencies&orTags=0Search results matching tags 'T-SQL', '2005', and 'Object Dependencies'en-USCommunityServer 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:20694manowar<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>