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

Scripts with tag Database Rss

Search for any content tagged database

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 16 of 16   

Generic, parameterised, create DB script

A script to be used as part of development deployments where new databases are required, so as to provide standardisation.  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 305 reads

Recompile All Databases stored Procedures

When code is getting stall, sometimes the execution plans are point to the wrong or out dated or old objects. You would need to recompile all the stored procedures  Read more...
By Mark Huber 2016/10/14 | Source: | Category: recompile
Rating: |  Discuss |   Briefcase | 609 reads

Database autogrowth and initail size setup.

Set initial size and autogrowth of all database on a SQL instance in a go.  Read more...
By Rajesh Sharma 2016/06/21 | Source: | Category: database
Rating: |  Discuss |   Briefcase | 557 reads

Database checkout alert when SQL Starts

Receive an email alert with some health information when SQL SERVER starts.  Read more...
By Rajesh Sharma 2016/06/17 | Source: | Category: database
Rating: (not yet rated) |  Discuss |   Briefcase | 481 reads

Database Information

this script returns some good information about databases on an instance of SQL SERVER.  Read more...
By Rajesh Sharma 2016/05/05 | Source: | Category: database
Rating: (not yet rated) |  Discuss |   Briefcase | 302 reads

Log and report on table growth for trending

Log and report on table growth for trending, so you can track exactly which table(s) are your hotspots for growth.  Read more...
By Haden Kingsland (theflyingdba) 2016/06/09 | Source: | Category: tables
Rating: |  Discuss |   Briefcase | 752 reads

DBCC CHECKDB to a table

An enhanced version of a script originally posted by Robert Pearl some time ago. It now takes into account changes in the tabelresults for CHECKDB in latter versions of SQL Server.  Read more...
Rating: |  Discuss |   Briefcase | 618 reads

Database Backup Information Scripts

Scripts used to validate the backups information as below 1) Database Backups for all databases For Previous Week 2) Most Recent Database Backup for Each Database 3) Most Recent Database Backup for Each Database - Detailed 4) Databases Missing a Back-Up Within Past 24 Hours  Read more...
By Sathya Praveen 2015/11/25 | Source: | Category: database
Rating: |  Discuss |   Briefcase | 1,509 reads

Figure out recovery mode for each database

It is anoying that someone created a new database and left its recovery mode in simple and it caused your backup jobs to fail.  Read more...
By Michael Zhang 2015/11/23 | Source: | Category: database
Rating: |  Discuss |   Briefcase | 601 reads

Locate a column across databases

This utility will locate a column across a subset or all databases across a server. Can be configured to run across versions, and can search tables, views or both.  Read more...
Rating: |  Discuss |   Briefcase | 1,200 reads

Backup all SSAS databases using TSQL

Enumerates and backups all SSAS DB's 
By Theo Ekelmans 2015/05/13 | Source: | Category: automatic
Rating: |  Discuss |   Briefcase | 2,612 reads

Find Primary Column of all tables in database

This code helps in finding Primary Keys for all tables in a database.  Read more...
By Nitesh R Dedhia 2012/10/02 | Source: | Category: primary key (pk)
Rating: |  Discuss |   Briefcase | 1,390 reads

Create Normalised Databases with Powershell

Database creation with powershell SMO objects 
By Patrick Viennot 2012/07/06 | Source: | Category: powershell
Rating: |  Discuss |   Briefcase | 941 reads

Database size trending with powershell

a script to import all database sizes from a list of servers into a table using powershell for trending purposes YOU MUST DOWNLOAD CODEPLEX SQL SERVER MODULE FOR THIS TO WORK.  Read more...
By Gene Hunter 2014/08/29 | Source: | Category: powershell
Rating: |  Discuss |   Briefcase | 2,847 reads

sp_MSforeachtable:Add SQL objects to multiple database on a server.

By Mehernosh 2011/11/14 | Source: | Category: sp_msforeachtable
Rating: |  Discuss |   Briefcase | 575 reads

SQL Server System Report

Overview report for tracking key database performance metrics, general system stats, overall activity, and general server info, including: properties and settings, uptime, drive space, DB size allocation, growth stats, backups, jobs, index fragmentation, missing and unused indexes, and much more.  Read more...
By Sean Smith 2016/01/11 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 14,417 reads
   Items 1 to 16 of 16