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.

Relationship between users and Databases

Mon, 30 May 2011 06:00:00 UT

Show the users inside the databases

How to output datafiles location using sp_helpdb?

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.

Track database growth

Tue, 19 Jul 2011 06:00:00 UT

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

Make working with SQL a breeze
SQL Prompt 5 is the effortless way to write, edit, and explore SQL. It's packed with features such as code completion, script summaries, and SQL reformatting, that make working with SQL a breeze. Try it now.

Find information about all databases

Tue, 28 Apr 2009 20:10:50 UT

ALL database information

Database Growth History

Tue, 07 May 2013 06:00:00 UT

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

how get primary key in any database

Thu, 29 Jan 2009 07:00:00 UT

drop the primary key name is different for each database

Growth remaining for SQL Server 2005 databases

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.

How to Drop Unused Empty Redundant columns

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

Permission scripting over all databases

Wed, 10 Sep 2008 07:28:09 UT

Scripts permissions/roles for db user across all databases.

How to get list of Stored Procedure

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.

Set standard database options

Mon, 19 Sep 2011 06:00:00 UT

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

‘Disturbing Development’
Grant Fritchey & the DBA Team present the latest installment of the Top 5 hard-earned lessons of a DBA – read it now