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

Get your favourite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

<< Newer    Items 61 to 80 of 2943    Older >>
 

Modified SP_WHOM

Provides sp_who data plus a connection summary and lead blocker details.  Read more...
By David Kranes 2014/01/23 | Source: SQLServerCentral.com | Category: sp_whom
Rating: |  Discuss |   Briefcase | 1,879 reads

Advanced Display Table and Column Info

A view that presents Schema, Table, Fields and Data Types, Defaults and First 10 triggers for the table.  Read more...
By Luis Chiriff 2014/01/03 | Source: SQLServerCentral.com | Category: columns
Rating: |  Discuss |   Briefcase | 1,480 reads

Figure out the Blocking issue

This script will help you to get the culprit along with IP address and User name which helps us to determine the Blocking root cause.  Read more...
By Rajib Kundu 2013/12/16 | Source: SQLServerCentral.com | Category: blocking
Rating: |  Discuss |   Briefcase | 2,126 reads

How we can move the login which has Sysadmin role.

We are using sp_help_revlogin to make login script, but it doesn't enable the login which has sysadmin role. It is very common problem during server migration. We use the this technique to solve the issue.  Read more...
By Rajib Kundu 2013/12/09 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 874 reads

Progress Bar Simulation on SQL Server

Progress Bar Simulation on SQL Server  Read more...
By Richard Chero 2013/12/11 | Source: SQLServerCentral.com | Category: richard j. chero díaz
Rating: |  Discuss |   Briefcase | 2,561 reads

Generate Trigger DDL

Dynamically generate trigger DDL and write to individual SQL files.  Read more...
By David Kranes 2013/12/02 | Source: SQLServerCentral.com | Category: ddl triggers
Rating: |  Discuss |   Briefcase | 1,339 reads

Use HASHBYTES to identify changes

Use a hash to identify changes and process just the changed rows.  Read more...
By Jim Youmans 2013/11/25 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,722 reads

Script Login Differences

Compare the logins and users on two instances and generate a TSQL script to make them the same.  Read more...
By Richard Fryar 2013/11/26 | Source: SQLServerCentral.com | Category: logins
Rating: |  Discuss |   Briefcase | 1,385 reads

Create tables and indexes with a Store Procedure

If you want to get the CREATE TABLES for all your Database tables, now you just need to run this SP.  Read more...
By Dario Palladino 2013/11/27 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 1,611 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,389 reads

Capture User Auths For Database

This script captures user authorizations by database (default) or by SQL instance   Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 636 reads

Index Breakdown

Provides a robust breakdown of all indexes contained within a database allowing for quick analysis and identification of inefficient, redundant, unused, bloated, stale, and / or poorly architected indexes.  Read more...
By Sean Smith 2014/04/11 | Source: SQLServerCentral.com | Category: index
Rating: |  Discuss |   Briefcase | 2,245 reads

Compare Current IDENTITY Value to DataType's Boundary

This script finds all tables which contain IDENTITY property, and compares the current seed to the maximal boundary of the data type.  Read more...
By Arthur Gimpel 2013/11/18 | Source: SQLServerCentral.com | Category: identity
Rating: |  Discuss |   Briefcase | 496 reads

Powershell script to interactively move cluster resources

Powershell code to interactively move cluster resources between nodes. Intended for Windows 2012 and SQL 2012.  Read more...
By Rolando Hernandez 2013/11/19 | Source: SQLServerCentral.com | Category: sql server 2012
Rating: (not yet rated) |  Discuss |   Briefcase | 427 reads

Search Table And Field In All Database And Return Field Value

In this script, we can search a Field and Table in all databases on the server, returning the Field value.  Read more...
By Babak Pirooz 2013/11/15 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 473 reads

Search Table And Field In All Database And Return Field Value

In this script, we can search a Field and Table in all databases on the server, returning the Field value.  Read more...
By Babak Pirooz 2013/11/15 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 627 reads

Generate row constructors for existing data

Takes a given table and generates a UNION ALL'd set of rows from the table. Useful for copying small amounts of data without the need for SSIS or import/export wizard  Read more...
By Gabe Tower 2013/11/14 | Source: SQLServerCentral.com | Category: rows
Rating: |  Discuss |   Briefcase | 1,043 reads

Script All Logins / Users / and Roles

This Script Generates A script to Create all Logins, Server Roles, DB Users and DB roles on a SQL Server.   Read more...
By Greg Ryan 2013/11/12 | Source: SQLServerCentral.com | Category: logins
Rating: |  Discuss |   Briefcase | 2,416 reads

Script to determine if two instances are on the same node

Determines if two instances of a Active/Active cluster are running on the same node.  Read more...
By Gregory Ferdinandsen 2013/11/13 | Source: SQLServerCentral.com | Category: wmi
Rating: |  Discuss |   Briefcase | 721 reads

SQL Data File Information

This script displays all data files within a SQL Server database with the following relevant properties: FileName, FileLocation, FileSizeMB, SpaceUsedMB, AvailableSpaceMB, %FreeSpace, FileGrowthMB and FileGroupName  Read more...
By Avinash Bookwala 2013/11/11 | Source: SQLServerCentral.com | Category: file size
Rating: |  Discuss |   Briefcase | 1,301 reads
<< Newer    Items 61 to 80 of 2943    Older >>