Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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

<< Newer    Items 21 to 40 of 162    Older >>
 

Display Names and Locations of SQL Database Files and DB Owners

Displays the names of all of the SQL databases on a SQL Server instance, their data and transaction log files, their owner, and their physical locations.  Read more...
By Charles Brinkman 2012/08/20 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,449 reads

Count of Objects by Database on a Server

I needed to get a count of objects by database on a server to assess which dbs are good candidates for Red Gate SQL Source Control.   Read more...
By Joe Kennedy 2012/08/07 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 649 reads

Finding Unused Database Roles

This is a data quality script that locates unused Database Roles for maintenance purposes  Read more...
By Brandie Tarvin 2012/07/24 | Source: SQLServerCentral.com | Category: database roles
Rating: |  Discuss |   Briefcase | 1,296 reads

All SQL Version info in one function

This function returns all the necessary version information in a table.  Read more...
By Wilfred van Dijk 2012/05/28 | Source: SQLServerCentral.com | Category: version
Rating: |  Discuss |   Briefcase | 3,058 reads

Session complete status and estimated completion time

A small retake on the popular percent complete script which tell how much more time an executing command will take.  Read more...
By Hemanth Damecharla 2012/03/21 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 909 reads

View Active Session SQL

This script can be used to view current SQL statements being executed for all or any one SPID.  Read more...
By David Kranes 2014/01/06 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 4,132 reads

Wait Time - Query\Client

Script helps to get the client and queries that generate longer waiting time.  Read more...
By Wellington Vitoriano 2011/11/07 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,414 reads

Database Files Physical Location

Displaying the SQL Database names and its associated files in the System drives in which the files are stored / mapped.  Read more...
By Mohamed Qasim 2011/11/11 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,123 reads

Next grow for all databases per disk

This script lets you to know how much disk space will be left after the next database grow taking in account the free space left in the database.   Read more...
By Gonzalo Moles 2011/10/11 | Source: SQLServerCentral.com | Category: maintenance
Rating: |  Discuss |   Briefcase | 972 reads

sp_who3

A compatibility view for DBAs used to using sp_who2  Read more...
By gerhard-356547 2011/08/01 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,984 reads

Get information from tables

Give information in tables such as type size and description of each of the columns  Read more...
By kenneth9 2011/07/08 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,427 reads

Verify a database backup using T-SQL

A script to verify a database backup using T-SQL code  Read more...
By Nakul Vachhrajani 2011/07/11 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,661 reads

Backup all databases & check backups

Stored procedure to backup all DB (chose user or system). You can do full, differential and log backups  Read more...
By Pavle-192195 2011/05/13 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,807 reads

Killing User Connection(session) connected to the Database.

The script will be helpful to kill all the user sessions before performing the refresh of the database.  Read more...
By S M 2011/04/08 | Source: SQLServerCentral.com | Category: kill
Rating: |  Discuss |   Briefcase | 2,383 reads

Index Defragmentation and update stats

A thorough SP for rebuilding indexes.  Read more...
By Gregory Ferdinandsen 2011/03/15 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 3,257 reads

Kill all connection to database

Procedure tries to kill all connections to the specified database.  Read more...
By Rafal Skotak 2011/03/01 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 3,861 reads

Unused Indexes in your databases

This Script allows you to determine the list of unused indexes in your databases. For sys.dm_db_indexes_usage_stats, make sure that the last rebbot of the service sql allows you to conclude  Read more...
By Rabie Harriga 2011/03/17 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 5,129 reads

(new) Kill ALL Connections To a SQL Database

Ever puzzled by the database "Currently in Use" error even though you thought all connections had been Killed? That’s because the wrong table SysProcesses was used.  Read more...
By Richard Lu 2011/02/15 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 3,342 reads

SQL Server Port Number Identifier

Find SQL server port number for SQL 2000, 2005, 2008 and 2008 R2  Read more...
By Rudy Panigas 2011/01/21 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,649 reads

TempDB usage per active session

Lists the TempDB usage per each active session.   Read more...
Rating: |  Discuss |   Briefcase | 7,594 reads
<< Newer    Items 21 to 40 of 162    Older >>