Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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 3119    Older >>
 

Verify Login SID and Machine SID

This script is to verify which login accounts have SID values that don’t match the correct SID values defined on the machine or in the domain.  Read more...
Rating: |  Discuss |   Briefcase | 1,246 reads

Migrate existing DB Mail Exchange Configuration with New

Sometime due to the heavy load in Exchange servers we received configuration alerts notifications and report delay and that time it is require to move to some other exchange servers to full fill the requirement during the critical periods.  Read more...
By Nitin Gupta 2015/01/13 | Source: SQLServerCentral.com | Category: dbmail
Rating: (not yet rated) |  Discuss |   Briefcase | 529 reads

Find Deny permissions on database objects

This script allows the DBA to quickly determine if a deny statement is stopping a user from accessing db objects.  Read more...
Rating: |  Discuss |   Briefcase | 736 reads

Automatic restore database to different server from backup file

if you get bunch of back up files ( full backup and transaction log backup, you need restore those database to different server, you can use my stored procedure to genereate the restore command   Read more...
By David Zhou 2015/01/15 | Source: SQLServerCentral.com | Category: restore
Rating: (not yet rated) |  Discuss |   Briefcase | 1,464 reads

Function for String Occurences Count

This function is used to get the particular string occurences count from the given input string.  Read more...
Rating: |  Discuss |   Briefcase | 971 reads

Calculate Power - Most Advanced UOC

This function is used to calculate the actual unit of conversion for power.  Read more...
By Vignesh Arulmani 2015/01/23 | Source: SQLServerCentral.com | Category: unit of conversion
Rating: |  Discuss |   Briefcase | 745 reads

Calculate Volume - Most Advanced UOC

This function is used to calculate the actual unit of conversion for volume.  Read more...
By Vignesh Arulmani 2015/01/30 | Source: SQLServerCentral.com | Category: unit of conversion
Rating: |  Discuss |   Briefcase | 744 reads

Calculate Time - Most Advanced UOC

This function is used to calculate the actual unit of conversion for time.  Read more...
By Vignesh Arulmani 2015/01/19 | Source: SQLServerCentral.com | Category: unit of conversion
Rating: |  Discuss |   Briefcase | 886 reads

Calculate Length - Most Advanced UOC

This function is used to calculate the actual unit of conversion for length.  Read more...
By Vignesh Arulmani 2015/02/06 | Source: SQLServerCentral.com | Category: unit of conversion
Rating: |  Discuss |   Briefcase | 754 reads

Copy Latest Backups from Backup Path

This script is useful to copying latest backup files from job Backup path during Instance/Database Migration  Read more...
By Ajay Dwivedi 2015/01/21 | Source: SQLServerCentral.com | Category: latest backup
Rating: (not yet rated) |  Discuss |   Briefcase | 620 reads

Script to remove Backup Files except Recent One for Same Day

This script is useful to remove SQL backup files except latest one for same day from Backup Path.  Read more...
By Ajay Dwivedi 2015/01/26 | Source: SQLServerCentral.com | Category: filter backup
Rating: (not yet rated) |  Discuss |   Briefcase | 883 reads

Stupid Coding Tricks: The T-SQL Mandelbrot

The bar for entry into CodeSOD is pretty straight forward: professionally-developed code that elicits that certain What The— reaction. Though there have been a few exceptions over the years, generally speaking, student code, hobbyist code, and amateur code need not apply. That said, I'd like to try something a little different today. Today's example is not technically professionally-developed, it's a Stupid Coding Trick. "So I was bored at work one day," Graeme Job explains, "and wondered, what's the most useless thing I could do with my time without actually doing anything. Then it hit me. I could use T-SQL to generate... Mandelbrot." Graeme continued, "Following is a single T-SQL SELECT statement that generates a text-representation of a Mandelbrot Set. The results are best viewed in text-mode."  Read more...
By gogulatorul 2015/01/20 | Source: SQLServerCentral.com | Category: humor
Rating: |  Discuss |   Briefcase | 2,516 reads

Calculate Pressure - Most Advanced UOC

This function is used to calculate the actual unit of conversion for pressure.  Read more...
By Vignesh Arulmani 2015/02/13 | Source: SQLServerCentral.com | Category: unit of conversion
Rating: |  Discuss |   Briefcase | 480 reads

Calculate Velocity - Most Advanced UOC

This function is used to calculate the actual unit of conversion for velocity/speed.  Read more...
By Vignesh Arulmani 2015/02/20 | Source: SQLServerCentral.com | Category: unit of conversion
Rating: |  Discuss |   Briefcase | 482 reads

Calculate Temperature - Most Advanced UOC

This function is used to calculate the actual unit of conversion for temperature.  Read more...
By Vignesh Arulmani 2015/01/09 | Source: SQLServerCentral.com | Category: unit of conversion
Rating: |  Discuss |   Briefcase | 935 reads

Calculate Energy - Most Advanced UOC

This function is used to calculate the actual unit of conversion for energy.  Read more...
By Vignesh Arulmani 2014/12/30 | Source: SQLServerCentral.com | Category: unit of conversion
Rating: |  Discuss |   Briefcase | 666 reads

Calculate Angle - Most Advanced UOC

This function is used to calculate the actual unit of conversion for angle.  Read more...
By Vignesh Arulmani 2015/01/06 | Source: SQLServerCentral.com | Category: unit of conversion
Rating: |  Discuss |   Briefcase | 598 reads

Calculate Area - Most Advanced UOC

This function is used to calculate the actual unit of conversion for area.  Read more...
By Vignesh Arulmani 2015/01/02 | Source: SQLServerCentral.com | Category: unit of conversion
Rating: |  Discuss |   Briefcase | 633 reads

Dynamic Script to Generate RESTORE DATABASE Script

Use this script to generate RESTORE DATABASE scripts for all .BAK backup files from backup location during Instance or Database migration.  Read more...
By Ajay Dwivedi 2015/01/05 | Source: SQLServerCentral.com | Category: migration
Rating: |  Discuss |   Briefcase | 1,439 reads

Calculate Mass/Weight - Most Advanced UOC

This function is used to calculate the actual unit of conversion for mass.  Read more...
By Vignesh Arulmani 2015/01/01 | Source: SQLServerCentral.com | Category: unit of conversion
Rating: |  Discuss |   Briefcase | 498 reads
<< Newer    Items 21 to 40 of 3119    Older >>