Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts with tag SQL Server Rss

Search for any content tagged sql server

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 24    Older >>
 

Database autogrowth and initail size setup.

Set initial size and autogrowth of all database on a SQL instance in a go.  Read more...
By Rajesh Sharma 2016/06/21 | Source: SQLServerCentral.com | Category: database
Rating: |  Discuss |   Briefcase | 537 reads

Database checkout alert when SQL Starts

Receive an email alert with some health information when SQL SERVER starts.  Read more...
By Rajesh Sharma 2016/06/17 | Source: SQLServerCentral.com | Category: database
Rating: (not yet rated) |  Discuss |   Briefcase | 444 reads

Agent Job Schedule Description

Yet another schedule description query with added grammatical improvements.  Read more...
By Michael McCormick 2016/05/06 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 544 reads

Delete all files from a folder using xp_cmdshell

Delete all files from a folder using xp_cmdshell  Read more...
Rating: |  Discuss |   Briefcase | 863 reads

Extract default & Named Instance from @@servername

Extract default & Named Instance from @@servername. Print all characters before and after \ to find default and named instance name.  Read more...
Rating: |  Discuss |   Briefcase | 959 reads

Check if SQL Server is running

This script will check if the SQL Server you are connected to is actually running.  Read more...
By Steve Jones 2015/04/01 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 1,614 reads

Querying deadlock graph from SQL Extended Events

Sample script to read deadlock graph XML from default system health XEvent.  Read more...
By Marcelo Fonseca 2016/09/16 | Source: SQLServerCentral.com | Category: xevents
Rating: |  Discuss |   Briefcase | 3,060 reads

Extract SQL Server Key details

Extract SQL Server Name, Instance Name, Service Account details, startMode and ServiceState details with Powershell.  Read more...
By S M 2014/10/27 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 1,415 reads

Simplest way to search any string in db objects

Easiest way to search for a string in any object within the database.  Read more...
By Kshitij Satpute 2013/08/08 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,255 reads

Fastest way to find DB object dependencies

One of the fastest ways to find out objects dependencies in SQL Server.  Read more...
By Kshitij Satpute 2015/04/07 | Source: SQLServerCentral.com | Category: dependencies
Rating: |  Discuss |   Briefcase | 3,180 reads

Fastest way to split delimited string in SQL Server

Getting rid of R-BAR to split a delimited string. This method is popular for it's simplicity, speed and zero reads.  Read more...
By Kshitij Satpute 2015/03/17 | Source: SQLServerCentral.com | Category: split string
Rating: |  Discuss |   Briefcase | 4,611 reads

Retrieve SQL Instance Connect Info

This script quickly returns Server Name, Cluster Node, Default Drive Letter for MSDB database, IP address and port  Read more...
Rating: |  Discuss |   Briefcase | 1,415 reads

Finding out whether you are using enterprise level feature

The query tells whether sql server enterprise edition is using any enterprise level features or not   Read more...
By Rahul Singh 2013/01/21 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 1,133 reads

Get an alert whenever SQL Server restarts

This script will create a job and it will send a mail whenever SQL server restarts.  Read more...
By SAI TEJA 2012/11/05 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 1,148 reads

Unattended Install with PowerShell

A PowerShell script which will guide you through an interview and produce the configuration file(s) necessary for an unattended installation of SQL Server 2008/2008R2.  Read more...
By Derik Hammer 2012/08/15 | Source: SQLServerCentral.com | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 1,559 reads

Session complete status and estimated completion time

A small retake on the popular percent complete script which tell how much more time an executing command will take.  Read more...
By Hemanth Damecharla 2012/03/21 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 933 reads

Get SQL Server IP Address

To Get Server IP Address without having to log into box or RDP  Read more...
By Shirley Bouzon 2011/08/02 | Source: SQLServerCentral.com | Category: ip addresses
Rating: |  Discuss |   Briefcase | 2,941 reads

NetApp Dynamic Backup Script

TSQL Script to backup selected databases. Use this to override the script generated by snapmanager for sql in a sql job which doesn't cater for new or deleted databases  Read more...
By Chris Taylor 2011/08/09 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 762 reads

Rateio do valor do Item na Nota - Totvs RM

Essa função calcula a porcentagem do Item em relação ao valor da nota. Aplicável a Totvs RM. Em especial RM Núcleus.  Read more...
By wamj 2011/07/13 | Source: SQLServerCentral.com | Category: totvs rm
Rating: (not yet rated) |  Discuss |   Briefcase | 117 reads

Changing Foreign key names to standard naming convention across the DB

Rename the Foreign keys to standard notation - FK_childTable_ParentTable  Read more...
By Vidyadhar Pandekar 2010/02/24 | Source: SQLServerCentral.com | Category: foreign keys (fk)
Rating: |  Discuss |   Briefcase | 1,128 reads
   Items 1 to 20 of 24    Older >>