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

   Items 1 to 20 of 3481    Older >>

Full text catalog and Full text Index

Full text catalog and Full text Index is simple and very powerful in SQL Server. We will create it with examples  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 11 reads

Grant Sp_who2, & who3 proc execution without granting sysadmin access

It will help to development team to find their developed & DB server status check.  Read more...
By Subhash Chandra 2018/03/22 | Source: SQLServerCentral.com | Category: db administration
Rating: |  Discuss |   Briefcase | 11 reads

ON Keyword for File Group in SQL Server 2017

ON Keyword usage in SELECT INTO clause is introduced in SQL SERVER 2017 which supports loading a table into a specific File Group using the ON keyword   Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 6 reads

Statistics Outdated

Busca por todas as estatísticas que estão desatualizadas com base no threshold do TraceFlag 2371.  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 19 reads

Change the server name of the SQL Server Instance

How to change the server name of SQL Server Instance?  Read more...
By PremKumar Raju 2018/03/19 | Source: SQLServerCentral.com | Category: sql server instance
Rating: (not yet rated) |  Discuss |   Briefcase | 8 reads

SQL server graph database

SQL Server has a feature to implement many-to-many relationships model. SQL server graph database capabilities is available in SQL Server 2017. Let us see the codes to implement the same.  Read more...
By Jayendra Viswanathan 2018/03/19 | Source: SQLServerCentral.com | Category: graph databases
Rating: (not yet rated) |  Discuss |   Briefcase | 14 reads

Quick ADD & ALTER Generator

Generate Add & Alter columns from an existing database  Read more...
By Khaled Dev 2018/03/19 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |   Briefcase | 241 reads


To get information for all SQL Server Services on a given SQL Server instance   Read more...
By Patrick Slesicki 2018/03/09 | Source: SQLServerCentral.com | Category: service accounts
Rating: |  Discuss |   Briefcase | 249 reads

Get date for iteration of a DOW

Good for Thanksgiving, Daylight Savings changes, Others? 
By Sean Senneka 2018/02/23 | Source: SQLServerCentral.com | Category: date computation
Rating: |  Discuss |   Briefcase | 78 reads

Logins for Windows Groups

Returns all user logins for Windows groups registered on the instance.   Read more...
By Patrick Slesicki 2018/02/26 | Source: SQLServerCentral.com | Category: login
Rating: |  Discuss |   Briefcase | 280 reads


To find record differences between publisher and subscriber tables by comparing primary keys.  Read more...
By Patrick Slesicki 2018/02/16 | Source: SQLServerCentral.com | Category: replication
Rating: (not yet rated) |  Discuss |   Briefcase | 174 reads

HTML Table Results For Email

HTML Table formatted results of a view or table for emailing  Read more...
By M Higgins 2018/02/19 | Source: SQLServerCentral.com | Category: html
Rating: (not yet rated) |  Discuss |   Briefcase | 453 reads

All Link servers working status check and failure alert over E-mail

This procedure will help you to automation of link server failure status check with help of SQL agent job scheduling. Job query :- exec proc_check_linked_servers 'profiler name','E-mail ID'  Read more...
By Subhash Chandra 2018/02/07 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 232 reads

Remove Database Encryption Key on all user databases

Below script will remove database encryption key, database certificate and master key on all the user databases. For tempdb database, you need to restart the SQL Server Instance to complete the process. Note: It is advisable to take transaction log backup before this activity is performed.  Read more...
Rating: |  Discuss |   Briefcase | 153 reads

Recent database restores

The scrip returns history of database restores from MSDB  Read more...
By Evgeny Garaev 2018/02/12 | Source: SQLServerCentral.com | Category: database restore
Rating: (not yet rated) |  Discuss |   Briefcase | 164 reads

Run SQL/T-SQL scripts on folder

What to do when you have several sql scripts to run in your DB? Put all in a folder and use this...  Read more...
By Daniel Marques 2018/02/09 | Source: SQLServerCentral.com | Category: scripts
Rating: |  Discuss |   Briefcase | 841 reads

Compare MS SQL Agent jobs on two servers

During a database migration or a side by side database upgrade project we need to migrate the MS SQL Server Agent jobs. This script compare jobs by names and shows unmatched jobs.  Read more...
By Evgeny Garaev 2018/01/25 | Source: SQLServerCentral.com | Category: ms sql server agent
Rating: |  Discuss |   Briefcase | 228 reads

How to read an audit file

The script reads data from audit files for a particular audit  Read more...
By Evgeny Garaev 2018/01/26 | Source: SQLServerCentral.com | Category: sql server audit
Rating: |  Discuss |   Briefcase | 275 reads

A Data Dictionary Select

Query for data dictionary using internals. Various constraint definitions included.  Read more...
By Patrick Slesicki 2018/03/14 | Source: SQLServerCentral.com | Category: data dictionary
Rating: |  Discuss |   Briefcase | 659 reads

Compression estimates

The script estimate compression benefits per each object in the database for which the page compression has not been implemented.  Read more...
By Evgeny Garaev 2018/02/15 | Source: SQLServerCentral.com | Category: compression
Rating: |  Discuss |   Briefcase | 199 reads
   Items 1 to 20 of 3481    Older >>