http://www2.sqlblog.com/blogs/adam_machanic/archive/2009/04/16/connect-item-globally-scoped-metadata-views.aspxEver tried writing a more or less database-agnostic administrative script? If the experience didn't make your head spin, you either have a stronger constitution than most DBAs or your script doesn't actually work properly. The fact is, due to the wayenCommunityServer 2.1 SP2 (Build: 61129.1)http://www2.sqlblog.com/blogs/adam_machanic/archive/2009/04/16/connect-item-globally-scoped-metadata-views.aspx#13330Thu, 16 Apr 2009 15:21:08 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:13330Alexander Kuznetsov<p>Great suggestion!</p> http://www2.sqlblog.com/blogs/adam_machanic/archive/2009/04/16/connect-item-globally-scoped-metadata-views.aspx#13332Thu, 16 Apr 2009 16:40:38 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:13332Michelle Ufford<p>Voted, 5 stars!</p> http://www2.sqlblog.com/blogs/adam_machanic/archive/2009/04/16/connect-item-globally-scoped-metadata-views.aspx#13334Thu, 16 Apr 2009 18:11:52 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:13334Ranga Narasimhan<p>Great Idea. voted 5 stars.</p> http://www2.sqlblog.com/blogs/adam_machanic/archive/2009/04/16/connect-item-globally-scoped-metadata-views.aspx#13350Sat, 18 Apr 2009 14:21:09 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:13350Saggi Neumann<p>Voted.</p> <p>It reminded me of another annoyance - index_id, used with and returned from sys.dm_db_index_physical_stats. Why aren't there index_name()/index_id() functions that can also take a database_id parameter, with ALTER INDEX the &quot;right way&quot; to rebuild/reorganize indexes? </p>