Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Scripts with tag Databases Rss

Search for any content tagged databases

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 13 of 13   

Size of database files for an instance of SQL Server

Size of database files for an instance of SQL Server  Read more...
By Andrés Michaca 2014/05/07 | Source: | Category: file size
Rating: |  Discuss |   Briefcase | 1,177 reads

Smart Index Rebuild - All Databases

Rebuilds all indexes from all databases over a specified fragmentation threshold.  Read more...
By Tim Hollobon 2015/09/04 | Source: | Category: indexing
Rating: |  Discuss |   Briefcase | 5,247 reads

Relationship between users and Databases

Show the users inside the databases 
By Ricardo Leka 2011/05/30 | Source: | Category: user
Rating: |  Discuss |   Briefcase | 2,310 reads

How to output datafiles location using sp_helpdb?

This is a quick way of outputting the location of your database files/dbsize/date created on your instance.   Read more...
By anthonyszm 2010/07/02 | Source: | Category: sp_helpdb
Rating: |  Discuss |   Briefcase | 1,232 reads

Track database growth

Script to keep track your database growth - Works with SQL 2000, 2005 & 2008  Read more...
By Irwan Tjanterik 2014/09/23 | Source: | Category: databases
Rating: |  Discuss |   Briefcase | 10,037 reads

Find information about all databases

ALL database information 
By umar iqbal 2009/04/28 | Source: | Category: databases
Rating: |  Discuss |   Briefcase | 2,248 reads

Database Growth History

This script uses the backup tables to get info on the growth of your database files.  Read more...
By Nicholas Williams 2013/05/07 | Source: | Category: growth
Rating: |  Discuss |   Briefcase | 6,843 reads

how get primary key in any database

drop the primary key name is different for each database  Read more...
By Furanshizuku 2009/01/29 | Source: | Category: primary key (pk)
Rating: |  Discuss |   Briefcase | 1,284 reads

Growth remaining for SQL Server 2005 databases

This script is little bit similar to the one posted for SQL Server 2000 that finds how much space you have left.  Read more...
By Mahidhar Vattem 2009/01/30 | Source: | Category: databases
Rating: |  Discuss |   Briefcase | 899 reads

How to Drop Unused Empty Redundant columns

Often during the development lifecycle columns are added to tables that become redundant or remain unused. this script removes unused (empty) columns  Read more...
By Chris Morton 2008/11/27 | Source: | Category: alter table
Rating: |  Discuss |   Briefcase | 1,150 reads

Permission scripting over all databases

Scripts permissions/roles for db user across all databases. 
By W Louw 2013/10/01 | Source: | Category: permissions
Rating: |  Discuss |   Briefcase | 13,755 reads

How to get list of Stored Procedure

You can use following stored procedure with four optional input parameters to get a list of all stored procedures in the current environment.  Read more...
By Tariq 2008/08/11 | Source: | Category: system stored procedure
Rating: |  Discuss |   Briefcase | 841 reads

Set standard database options

Ensure all your databases have standardised options by running this script weekly.  Read more...
By Ed Vassie 2011/09/19 | Source: | Category: sql server 7
Rating: |  Discuss |   Briefcase | 2,098 reads
   Items 1 to 13 of 13