SQLServerCentral.com Scripts tagged Databases

Smart Index Rebuild - All Databases

Thu, 08 Nov 2012 07:00:00 UT

Rebuilds all indexes from all databases over a specified fragmentation threshold.

Mon, 30 May 2011 06:00:00 UT

Show the users inside the databases

Fri, 02 Jul 2010 06:00:00 UT

This is a quick way of outputting the location of your database files/dbsize/date created on your instance.

Tue, 19 Jul 2011 06:00:00 UT

Script to keep track your database growth - Works with SQL 2000, 2005 & 2008

Tue, 28 Apr 2009 20:10:50 UT

ALL database information

Tue, 07 May 2013 06:00:00 UT

This script uses the backup tables to get info on the growth of your database files.

Thu, 29 Jan 2009 07:00:00 UT

drop the primary key name is different for each database

Fri, 30 Jan 2009 07:00:00 UT

This script is little bit similar to the one posted for SQL Server 2000 that finds how much space you have left.

Thu, 27 Nov 2008 07:00:00 UT

Often during the development lifecycle columns are added to tables that become redundant or remain unused. this script removes unused (empty) columns

Wed, 10 Sep 2008 07:28:09 UT

Scripts permissions/roles for db user across all databases.

Mon, 11 Aug 2008 18:51:03 UT

You can use following stored procedure with four optional input parameters to get a list of all stored procedures in the current environment.

Mon, 19 Sep 2011 06:00:00 UT

Ensure all your databases have standardised options by running this script weekly.