Click here to monitor SSC
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 3412    Older >>
 

Generate scripts for SQL Server Management Studio diagrams

The procedure generates an import script of diagrams.  Read more...
By Jonas Gunnarsson 2017/03/22 | Source: SQLServerCentral.com | Category: diagram
Rating: (not yet rated) |  Discuss |   Briefcase | 66 reads

Stored Proc Archives rows to another table

This will Archive and Purge rows from one table to another.  Read more...
By Farrell Thomas 2017/03/27 | Source: SQLServerCentral.com | Category: archive
Rating: |  Discuss |   Briefcase | 374 reads

Fix Orphan Users for All databases

Fix orphan database users on all user databases.  Read more...
Rating: |  Discuss |   Briefcase | 300 reads

Connect to MongoDB on Remote Linux Server with Powershell

Return values from MongoDB on Linux server with Powershell  Read more...
By Michael D'Spain 2017/03/20 | Source: SQLServerCentral.com | Category: mongodb
Rating: |  Discuss |   Briefcase | 121 reads

Find UDF useage

Find all stored procedures that use UDFs  Read more...
By Jim Youmans 2017/03/21 | Source: SQLServerCentral.com | Category: sql
Rating: (not yet rated) |  Discuss |   Briefcase | 275 reads

Find all published tables with row counts and table size

This script will show you all the tables that are being published with sizes.  Read more...
By Jim Youmans 2017/03/16 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 311 reads

SQL Login Password Audit

Audit you SQL Logins   Read more...
By Jim Youmans 2017/03/07 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |   Briefcase | 453 reads

Missing index with change impact percentage

This script will list all missing indexes with create statements.  Read more...
By Arun Kumar 2017/03/01 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 453 reads

Corrupt Page Notification

This trigger will send mail notification once a row is written in the suspect pages table  Read more...
By Henrico Bekker 2017/03/03 | Source: SQLServerCentral.com | Category: corruption
Rating: (not yet rated) |  Discuss |   Briefcase | 300 reads

Building calendar table using MTVF

This script is a small extension to this excellent article http://www.sqlservercentral.com/articles/calendar/145206/   Read more...
By Darko Martinovic 2017/03/28 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 891 reads

Getting resource content from blocked process report

This script serves to display the content of the waiting resource. It is divided in two parts. In first one I'm using t-sql, and in second one I accomplished the same task using SQLCRL.   Read more...
By Darko Martinovic 2017/02/27 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 302 reads

Getting resource name from blocked process report

The Resource name is most important information in the blocked process report. The purpose of this script is to decode this information. The script is divided in two parts. In first one I'm using t-sql, and in second one I accomplished the same task using SQLCRL.   Read more...
By Darko Martinovic 2017/03/02 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 357 reads

Tally Generator

Inline function generating the set of numbers based on submitted parameters.   Read more...
By Sergiy Floka 2017/03/08 | Source: SQLServerCentral.com | Category: tally
Rating: |  Discuss |   Briefcase | 906 reads

Check if xp_cmdshell is turned on and flip the bit

The code works well for an automation process that needs to have xp_cmdhsell turned on.  Read more...
By Edward Pochinski 2017/02/22 | Source: SQLServerCentral.com | Category: xp_cmdshell
Rating: (not yet rated) |  Discuss |   Briefcase | 257 reads

AdventureWorks2016CTP3 - JSON Sample scripts

Geting the JSON Sample Scripts to run   Read more...
By Mick Rust 2017/01/31 | Source: SQLServerCentral.com | Category: adventureworks2016ctp3
Rating: |  Discuss |   Briefcase | 252 reads

Find Text in All Databases

Search all databases for a particular string.  Read more...
By Jason Givens 2017/01/30 | Source: SQLServerCentral.com | Category: sp_msforeachdb
Rating: |  Discuss |   Briefcase | 551 reads

Powershell Script to find a SQL\Windows login in SQL Server

This script will help you to find out whether a particular id (SQL or Windows ID) is present in the SQL Server  Read more...
By Vishnu Gupthan 2017/01/26 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 387 reads

Generic, parameterised, create DB script

A script to be used as part of development deployments where new databases are required, so as to provide standardisation.  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 322 reads

TDE Decryption Timer Script

Decryption Timer to let you know when the removal of encryption for a TDE encrypted database has completed to perform a backup of the data after masking.  Read more...
By Edward Pochinski 2017/01/24 | Source: SQLServerCentral.com | Category: tde
Rating: |  Discuss |   Briefcase | 302 reads

Count Year,Month,Day

This Syntax will help you to search how many period left your data/assets must be followed up or changed or disposed  Read more...
By Deny Christian 2017/01/25 | Source: SQLServerCentral.com | Category: date manipulation
Rating: |  Discuss |   Briefcase | 495 reads
   Items 1 to 20 of 3412    Older >>