Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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: SQLServerCentral.com | Category: file size
Rating: |  Discuss |   Briefcase | 943 reads

Smart Index Rebuild - All Databases

Rebuilds all indexes from all databases over a specified fragmentation threshold.  Read more...
By Tim Hollobon 2013/12/12 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 3,157 reads

Relationship between users and Databases

Show the users inside the databases  Read more...
By Ricardo Leka 2011/05/30 | Source: SQLServerCentral.com | Category: user
Rating: |  Discuss |   Briefcase | 2,206 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,219 reads

Track database growth

Script to keep track your database growth - Works with SQL 2000, 2005 & 2008  Read more...
By Irwan Tjanterik 2014/01/16 | Source: SQLServerCentral.com | Category: databases
Rating: |  Discuss |   Briefcase | 8,054 reads

Find information about all databases

ALL database information  Read more...
By umar iqbal 2009/04/28 | Source: SQLServerCentral.com | Category: databases
Rating: |  Discuss |   Briefcase | 2,013 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 | 5,591 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,262 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 | 872 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,139 reads

Permission scripting over all databases

Scripts permissions/roles for db user across all databases.  Read more...
By W Louw 2013/10/01 | Source: SQLServerCentral.com | Category: permissions
Rating: |  Discuss |   Briefcase | 12,457 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 | 780 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,061 reads
   Items 1 to 13 of 13