http://www.sqlservercentral.com/Content tagged Administration, SQL Server 2005, Maintenance and Management, Search posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Lists Schema/Object of tables that are missing a Primary Key or Clustered Index, along with aggregate data for size, rows, indexes, and columns.http://www.sqlservercentral.com/scripts/Administration/64880/2008/11/05http://www.sqlservercentral.com/scripts/Administration/64880/Searches for tables who's names contain the search string. Gives Aggregate Size, Rows, Index, and Column information as well.http://www.sqlservercentral.com/scripts/Administration/64870/2008/11/04http://www.sqlservercentral.com/scripts/Administration/64870/Searches for tables who's names contain the search string. Gives Size and Rows information as well.http://www.sqlservercentral.com/scripts/Administration/63929/2008/10/30http://www.sqlservercentral.com/scripts/Administration/63929/Searches precompiled procedures for the provided search string, optionally limiting to names matching a 2nd search string.http://www.sqlservercentral.com/scripts/SQL+Server+2005/63508/2008/08/29http://www.sqlservercentral.com/scripts/SQL+Server+2005/63508/Searches for actual and potential foreign key columns for a given primary key reference.http://www.sqlservercentral.com/scripts/T-SQL/63509/2008/08/15http://www.sqlservercentral.com/scripts/T-SQL/63509/Searches for columns with names containing @Colname that belong to tables with names containing @TableName or schemas with names containing @SchemaName. Gives size and rowcount for tables.http://www.sqlservercentral.com/scripts/Administration/63928/2008/08/01http://www.sqlservercentral.com/scripts/Administration/63928/