Provide list of Stored Procedures that have been changed in past 7 days.  Read more...

Script to find the total used size of all database inside SQL Server  Read more...

List all tables in a SQL Server database with the details of them.  Read more...

Use sp_MSForeEachDB to set all 1 MB file growth databases to 10%.   Read more...

It shrinks all log files for the databases created by users.  Read more...

This script is used to get uptime for the SQL Server. (Supports SQL2005 and onwards only)  Read more...

There are other options available like Sql search from Red Gate. Here's a simple script to search for table(s) containing a particular keyword. You can easily extend it to other type of objects by changing the Xtype.  Read more...

Displays the names of all of the SQL databases on a SQL Server instance, their data and transaction log files, their owner, and their physical locations.  Read more...

I needed to get a count of objects by database on a server to assess which dbs are good candidates for Red Gate SQL Source Control.   Read more...

This is a data quality script that locates unused Database Roles for maintenance purposes  Read more...

This function returns all the necessary version information in a table.  Read more...

This script can be used to view current SQL statements being executed for all or any one SPID.  Read more...

Script helps to get the client and queries that generate longer waiting time.  Read more...

Displaying the SQL Database names and its associated files in the System drives in which the files are stored / mapped.  Read more...

This script lets you to know how much disk space will be left after the next database grow taking in account the free space left in the database.   Read more...

A compatibility view for DBAs used to using sp_who2  Read more...

Give information in tables such as type size and description of each of the columns  Read more...

A script to verify a database backup using T-SQL code  Read more...

Stored procedure to backup all DB (chose user or system). You can do full, differential and log backups  Read more...

The script will be helpful to kill all the user sessions before performing the refresh of the database.  Read more...