SQL Clone
SQLServerCentral is supported by Redgate
 
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

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

dba_CopyLogins

A copy of the late Robert Davis' dba_copylogins stored procedure with a bug fix. The SP copies logins, roles, and permissions between servers.  Read more...
By Chuck Hamilton 2018/09/24 | Source: SQLServerCentral.com | Category: copy logins
Rating: |  Discuss |   Briefcase | 295 reads

Compare Table Contents Procedure

Compare the content of two tables for differences   Read more...
By Damir Sprecic 2018/09/20 | Source: SQLServerCentral.com | Category: compare
Rating: |  Discuss |   Briefcase | 331 reads

GenerateFullSequenceRestoreScripts_Litespeed

Sp to Generate Restore sequence  Read more...
By Harkamal Singh 2018/09/04 | Source: SQLServerCentral.com | Category: backup and restore
Rating: |  Discuss |   Briefcase | 196 reads

FK_Add_Drop_Constraints_AllDBs

This scripts helps to generate ADD / DROP Constraints against single Database.  Read more...
By Aswini G 2018/09/03 | Source: SQLServerCentral.com | Category: table constraints
Rating: |  Discuss |   Briefcase | 161 reads

Table Space Used in DB

A quick script that provides the sizes of the tables in your database, including schema and choice of sort method  Read more...
By Luis Chiriff 2018/08/07 | Source: SQLServerCentral.com | Category: sp_spaceused
Rating: |  Discuss |   Briefcase | 452 reads

SQL table to HTML

Convert any table or select query to a html table format  Read more...
By Eduardo Pivaral 2018/08/09 | Source: SQLServerCentral.com | Category: tsql
Rating: |  Discuss |   Briefcase | 635 reads

Replace-Function

Another way to do a "Multi"- replace  Read more...
By Jonny Wallman 2018/08/13 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 421 reads

STRING and FIND SQL Functions

SQL Functions that simplify search and operations over strings on SQL Server (starting with 2012)  Read more...
By Pedro Costa 2018/07/11 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 618 reads

User Stored Procedure for Backup of user databases

This script is intended to demonstrate how we can create a stored procedure for the user responsible for backing up user databases in a default storage location.  Read more...
By Junior Galvão - MVP 2018/07/10 | Source: SQLServerCentral.com | Category: user database
Rating: |  Discuss |   Briefcase | 285 reads

Transactional Logs Restore

Testing Transaction Logs restore  Read more...
By Harsha Bhagat 2018/07/09 | Source: SQLServerCentral.com | Category: restore
Rating: (not yet rated) |  Discuss |   Briefcase | 232 reads

Create Database using dynamic SQL

The T-SQL script created a databases using the default file locations from SQL server configuration and prints them in the end.  Read more...
By Shridhar 2018/07/05 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 295 reads

Find the memory consumetion by each database

find the Memory used by each database  Read more...
By Subhash Chandra 2018/07/17 | Source: SQLServerCentral.com | Category: memory usage
Rating: |  Discuss |   Briefcase | 443 reads

User access management on DB & object level

It will help to find and manage the users access on DB level  Read more...
Rating: |  Discuss |   Briefcase | 259 reads

Entering random data into a table

Este bloco de código tem o objetivo de demonstrar como podemos inserir um quantidade de linhas de registro de dados aleatórios de uma tabela no Microsoft SQL Server.  Read more...
By Junior Galvão - MVP 2018/06/14 | Source: SQLServerCentral.com | Category: insert
Rating: |  Discuss |   Briefcase | 329 reads

Generate a script for FullText Catalogs and Indexes

This will generate a script for FullText catalogs and indexes  Read more...
By Bob Steen 2018/06/13 | Source: SQLServerCentral.com | Category: fulltext
Rating: (not yet rated) |  Discuss |   Briefcase | 206 reads

Export diagrams

Export diagrams in current database to an import script.  Read more...
By Jonas Gunnarsson 2018/09/21 | Source: SQLServerCentral.com | Category: diagram
Rating: |  Discuss |   Briefcase | 472 reads

Script out EXISTING database mail profile's settings

Script out EXISTING database mail profile settings  Read more...
By Subhash Chandra 2018/04/25 | Source: SQLServerCentral.com | Category: mail profile
Rating: |  Discuss |   Briefcase | 460 reads

Updated Brute Force Search Tool

searches a database for specified values  Read more...
By John Imel 2018/05/01 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 456 reads

Generate Large Amount of Data For Performance Testing

Generate large sample data for your performance and other uses  Read more...
Rating: |  Discuss |   Briefcase | 444 reads
<< Newer    Items 21 to 40 of 3539    Older >>