SQL Clone
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 14 of 14   

Quick ADD & ALTER Generator

Generate Add & Alter columns from an existing database  Read more...
By Khaled Dev 2018/03/19 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |   Briefcase | 296 reads

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: SQLServerCentral.com | Category: file size
Rating: |  Discuss |   Briefcase | 1,216 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: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 5,357 reads

Relationship between users and Databases

Show the users inside the databases 
By Ricardo Leka 2011/05/30 | Source: SQLServerCentral.com | Category: user
Rating: |  Discuss |   Briefcase | 2,346 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: SQLServerCentral.com | Category: sp_helpdb
Rating: |  Discuss |   Briefcase | 1,236 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: SQLServerCentral.com | Category: databases
Rating: |  Discuss |   Briefcase | 10,244 reads

Find information about all databases

ALL database information 
By umar iqbal 2009/04/28 | Source: SQLServerCentral.com | Category: databases
Rating: |  Discuss |   Briefcase | 2,305 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: SQLServerCentral.com | Category: growth
Rating: |  Discuss |   Briefcase | 7,213 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: SQLServerCentral.com | Category: primary key (pk)
Rating: |  Discuss |   Briefcase | 1,287 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: SQLServerCentral.com | Category: databases
Rating: |  Discuss |   Briefcase | 903 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: SQLServerCentral.com | Category: alter table
Rating: |  Discuss |   Briefcase | 1,156 reads

Permission scripting over all databases

Scripts permissions/roles for db user across all databases. 
By W Louw 2013/10/01 | Source: SQLServerCentral.com | Category: permissions
Rating: |  Discuss |   Briefcase | 13,950 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: SQLServerCentral.com | Category: system stored procedure
Rating: |  Discuss |   Briefcase | 857 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: SQLServerCentral.com | Category: sql server 7
Rating: |  Discuss |   Briefcase | 2,113 reads
   Items 1 to 14 of 14