Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

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 24    Older >>
 

backup, differental and transactions

Backup all databases for an instance (complete, Differential or log of transactions)   Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 635 reads

Count all records the tables

Count all the records from the tables that exist in a database  Read more...
Rating: |  Discuss |   Briefcase | 446 reads

Generate merge script for all primary key tables in a database

This code generates merge scripts in the form of individual stored procedures for each table within a specified database. Once executed, simply highlight the results within the following columns altogether and past into a new window: SET_OPERATOR, AND_OPERATOR, COLUMN_SQL Enjoy  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 846 reads

Server_Config_Script_2012

Here's a quick query you can run across all your servers (2012) to find a wealth of information like service pack, edition, number of CPUs and RAM. Even more is available if you want to add additional SERVERPROPERTY attributes or fields from one of the DMVs.  Read more...
Rating: |  Discuss |   Briefcase | 1,360 reads

Calculate Table Size and row count

This script calculates table row count and size(MB), as well as the used space and free space.  Read more...
Rating: |  Discuss |   Briefcase | 1,476 reads

Split and concatenate function

Function for splitting the values in string, applying logic and concatenating back to string.  Read more...
Rating: |  Discuss |   Briefcase | 1,406 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,153 reads

SQL Server Dynamic XML Tag

Extract data from XML file from dynamic tag. in this below e.g we can add / remove Escalations tag from xml file. and depends on that result will display.  Read more...
Rating: |  Discuss |   Briefcase | 685 reads

Check Candidate Columns for FOREIGN KEY Constraints

Reports table columns that are not foreign keys but that perhaps should be.  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 804 reads

Retrieve SQL Instance Connect Info

This script quickly returns Server Name, Cluster Node, Default Drive Letter for MSDB database, IP address and port  Read more...
Rating: |  Discuss |   Briefcase | 1,305 reads

2008 Index Rebuild using DMV

Index Maintenance procedure with HTML Reporting capabilities. Please refer to attached script for detailed information.  Read more...
Rating: |  Discuss |   Briefcase | 1,543 reads

Login Password Policy

This script lists all of the SQL logins with their password policy  Read more...
Rating: |  Discuss |   Briefcase | 1,574 reads

Operators With Jobs and Notifications

This script will list the operators that have jobs that are configured to notify them with alerts.  Read more...
Rating: |  Discuss |   Briefcase | 744 reads

who can do what?

list each user has the right to do  Read more...
Rating: |  Discuss |   Briefcase | 2,154 reads

Display multiple rows values as single row value (Different Columns)

Display multiple rows values as single row value in different rows (No Cursor).  Read more...
Rating: |  Discuss |   Briefcase | 2,900 reads

Data compression applied

It shows you the compression state of all indexes/tables of a database.  Read more...
Rating: |  Discuss |   Briefcase | 1,051 reads

Compress tables

It compresses all the tables/indexes in a database, a specific one or all the objects inside a database schema.  Read more...
Rating: |  Discuss |   Briefcase | 1,770 reads

Identify Allocation Contention in TEMPDB

Identifies potential page allocation contention in TEMPDB.  Read more...
Rating: |  Discuss |   Briefcase | 2,540 reads

TempDB usage per active session

Lists the TempDB usage per each active session.   Read more...
Rating: |  Discuss |   Briefcase | 5,492 reads

What Is Filling Up The Transaction Log

Report unusual conditions that may be filling up your transaction log.  Read more...
Rating: |  Discuss |   Briefcase | 4,523 reads
   Items 1 to 20 of 24    Older >>