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

Scripts with tag Administration Rss

Search for any content tagged administration

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 20 of 183    Older >>

Index and Column Configuration

Returns the indexes in a database along with all of the columns in the index in a consolidated format  Read more...
By Tennery Press 2016/05/17 | Source: | Category: index
Rating: (not yet rated) |  Discuss |   Briefcase | 42 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/05/05 | Source: | Category: database
Rating: |  Discuss |   Briefcase | 31 reads

Script DB Level Permissions v4

Script database and object level permissions for all database users  Read more...
By S. Kusen 2016/03/22 | Source: | Category: login
Rating: |  Discuss |   Briefcase | 833 reads

SQL server Service, Account, Trace Flag info

This script outputs sql server service, start type, status, Service Account, installation location, start up time, uptime of sql server related services along with startup trace flags.   Read more...
By Kin Shah 2015/12/17 | Source: | Category: sql agent
Rating: |  Discuss |   Briefcase | 934 reads

Script to configure Log File Size for Large DBs

Use this script to set recommended Log files size growth for larger DBs. For more, please refer article:  Read more...
By Ajay Dwivedi 2015/12/15 | Source: | Category: database configuration
Rating: |  Discuss |   Briefcase | 1,100 reads

Orphaned Database Files

A neat way to detect if there are any orphaned SQL database files taking up space on your server.  Read more...
By Geoffrey Woodward 2015/12/08 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 1,195 reads

Estimate compression for all tables and indexes with both Row and Page

This will log output of estimate compression for both PAGE and ROW for all tables and indexes  Read more...
By Doran Mackay 2015/12/10 | Source: | Category: compression
Rating: (not yet rated) |  Discuss |   Briefcase | 610 reads

Getting transaction log space usage statistics for all databases.

Easy way to get the TLOg space Usage details  Read more...
By S M 2015/12/07 | Source: | Category: space usage
Rating: |  Discuss |   Briefcase | 1,145 reads

Temporary exclusive database access

This simple script disconnects any other session that is connected to the specified database by temporarily switching the database to single user.  Read more...
By Tom Staab 2015/11/20 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 849 reads

List schemas in a database

This is an expansion of the sys.schemas table. User schemas are sorted to the top, schema type is decoded, schema authorization is included.  Read more...
By Chris Compton 2015/07/14 | Source: | Category: schema
Rating: |  Discuss |   Briefcase | 1,243 reads

Complete Details About Backups Taken a Day Ago

Complete Details About Backups Taken a Day Ago. 
By S M 2015/06/05 | Source: | Category: backup
Rating: |  Discuss |   Briefcase | 1,044 reads

Detach & Attach Procedure

For successful run, Your SQL Server service account should have permission to old location & new location  Read more...
By Vimal Lohani 2015/05/27 | Source: | Category: detach database
Rating: |  Discuss |   Briefcase | 946 reads

Query to find size of each disk file in a location

Query to find size of each file in a location  Read more...
By S M 2015/05/26 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 988 reads

Real World: SQL Server Quick Quality Check

Here is a script that can give the DBA a SQL Instance quick quality check.  Read more...
By Randeep Singh 2016/01/14 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 5,688 reads

Verify Login SID and Machine SID

This script is to verify which login accounts have SID values that don’t match the correct SID values defined on the machine or in the domain.  Read more...
Rating: |  Discuss |   Briefcase | 1,494 reads

Migrate existing DB Mail Exchange Configuration with New

Sometime due to the heavy load in Exchange servers we received configuration alerts notifications and report delay and that time it is require to move to some other exchange servers to full fill the requirement during the critical periods.  Read more...
By Nitin Gupta 2015/10/06 | Source: | Category: dbmail
Rating: |  Discuss |   Briefcase | 995 reads

Automatic restore database to different server from backup file

if you get bunch of back up files ( full backup and transaction log backup, you need restore those database to different server, you can use my stored procedure to genereate the restore command   Read more...
By David Zhou 2015/01/15 | Source: | Category: restore
Rating: (not yet rated) |  Discuss |   Briefcase | 1,901 reads

Copy Latest Backups from Backup Path

This script is useful to copying latest backup files from job Backup path during Instance/Database Migration  Read more...
By Ajay Dwivedi 2015/01/21 | Source: | Category: latest backup
Rating: (not yet rated) |  Discuss |   Briefcase | 788 reads

Script to remove Backup Files except Recent One for Same Day

This script is useful to remove SQL backup files except latest one for same day from Backup Path.  Read more...
By Ajay Dwivedi 2015/01/26 | Source: | Category: filter backup
Rating: (not yet rated) |  Discuss |   Briefcase | 983 reads

Retrieve instance-wide index level fill factor information

This script retrieves all fill factor information for all indexes (clustered and non) when it is not set to 0 or 100  Read more...
Rating: |  Discuss |   Briefcase | 601 reads
   Items 1 to 20 of 183    Older >>