I have made an update of this script http://qa.sqlservercentral.com/scripts/Metadata/64603/. the new version includes can generate 4 stored procedures for every table in a database
2013-01-08 (first published: 2008-10-23)
3,192 reads
Reports stats on what the query optimizer records in the DMVs as missing indexes and what it says the cost savings will be if they were present. Can limit by table / schema name patterns.
2013-01-07 (first published: 2008-08-01)
20,235 reads
Search for a text in all the stored Procedures in a Database
2013-01-04 (first published: 2009-01-14)
3,612 reads
Simple T-SQL to find failed SQL Agent jobs
2013-01-03 (first published: 2009-02-17)
7,381 reads
To find a list of Tables (User or System tables)according to their size.
2013-01-02 (first published: 2008-07-10)
4,248 reads
This Script generates drop and create scripts for views or stored procedures.
2013-01-01 (first published: 2007-10-19)
6,134 reads
Reports index stats, index size+rows, member seek + include columns as two comma separated output columns, and index usage stats for one or more tables and/or schemas.
2012-12-27 (first published: 2008-08-01)
7,756 reads
This is a simple script that show size from a table and yours related objects.
2012-12-24 (first published: 2007-09-27)
2,697 reads
This script will query across all databases, returning a result of objects recently created or modified.
2012-12-21 (first published: 2012-11-27)
1,643 reads
Convert Horizontal Hierarchy
to vertical Hierarchy.
2012-12-20 (first published: 2012-12-04)
1,266 reads