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 41 to 60 of 3439    Older >>
 

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 | 281 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 | 315 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 | 640 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 | 424 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 | 361 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 | 318 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 | 529 reads

Powershell Script for regular DBA activities

This script will perfrom following tasks : 1. BackUp DB 2. Restore DB from BackUp File 3. Restore DB from DB 4. Create a new DB from Existing Db It takes care of all the possible failures during these operations, while done manually.   Read more...
By Mayank Shukla 2017/01/11 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 1,178 reads

Backup databases in an Availability Group

Use this script to backup databases based on their role in an availability group  Read more...
By Kevin Burgess 2017/01/12 | Source: SQLServerCentral.com | Category: availability
Rating: (not yet rated) |  Discuss |   Briefcase | 273 reads

PoorDBA Tools - 1: DB Log Space used

Evaluate and notify if database log file usage exceeds 15%.  Read more...
By Henrico Bekker 2017/01/10 | Source: SQLServerCentral.com | Category: alerts
Rating: |  Discuss |   Briefcase | 682 reads

Query details about objects allocated in TEMPDB.

TEMPDB doesn't have to be a black box. Know what objects and processes are causing it to bloat in size.  Read more...
By Eric Russell 2017/01/30 | Source: SQLServerCentral.com | Category: tempdb
Rating: |  Discuss |   Briefcase | 1,077 reads

SQL Server ErrorLog Archive Script

An ErrorLog Archive and Clean Script  Read more...
By Yusuf Kahveci 2017/01/02 | Source: SQLServerCentral.com | Category: error log
Rating: (not yet rated) |  Discuss |   Briefcase | 346 reads

View Autogrowth on a daily basis

Sends an HTML formatted Email with autogrowth Information for the last 24 hours.  Read more...
By Kevin Burgess 2017/01/03 | Source: SQLServerCentral.com | Category: autogrow
Rating: |  Discuss |   Briefcase | 647 reads

T-SQL implementation of FizzBuzz

A T-SQL implementation of FizzBuzz consisting of a single SELECT statement.  Read more...
By Eric Russell 2016/12/28 | Source: SQLServerCentral.com | Category: fizzbuzz
Rating: |  Discuss |   Briefcase | 578 reads

SQL - Use SERVERPROPERTY to get SQL Instance Information

Returns property information about the server instance.  Read more...
By SQLisAwesome 2016/12/29 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 528 reads

Read SQL Server Logs with TSQL

This is a small script designed to read the Contents of the SQL Server log based on None or more criteria.   Read more...
By Kevin Burgess 2016/12/30 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 650 reads

Query Performance comparison between instances

Execute at source, and will generate an output with TSQL commands to create temp tables filled with top 50 long lasting queries from all databases. Then execute output at destination and will do the same and show comparison of matching queries!!   Read more...
By Rodrigo Acosta 2016/12/19 | Source: SQLServerCentral.com | Category: query
Rating: |  Discuss |   Briefcase | 604 reads

Check constraint to prevent insertion of invalid characters.

A column level check constraint may be used to prevent insertion of data containing characters within a specific ASCII range.  Read more...
By Eric Russell 2016/12/12 | Source: SQLServerCentral.com | Category: constraints
Rating: |  Discuss |   Briefcase | 1,018 reads

Truncate tables with foreign keys

Truncating tables with constraints always had been a pain, since we have to drop and recreate all the FKs. I created a script that takes care of dropping and recreating the foreign keys while truncating. Please use with caution! and always respect your Data !  Read more...
By Roshan Joe Joseph 2016/12/01 | Source: SQLServerCentral.com | Category: truncate
Rating: |  Discuss |   Briefcase | 731 reads

Fix Orphan Users

Fix Orphan Users  Read more...
By S M 2016/11/30 | Source: SQLServerCentral.com | Category: orphan users
Rating: |  Discuss |   Briefcase | 592 reads
<< Newer    Items 41 to 60 of 3439    Older >>