Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 

Add a script

   Items 1 to 20 of 2775    Next 20 >>
 

How to Backup All SQL Server Databases

How to backup all SQL Server databases at once.  Read more...
By Sunny Mendpara 2013/05/20 | Source: SQLServerCentral.com | Category: database backup
Rating: |  Discuss |   Briefcase | 557 reads

Format Currency Into a String

I had a requirement to produce a formatted currency string from within SQL server. I was able to build this scalar-valued function to meet the requirement.  Read more...
By Chris Kutsch 2013/05/13 | Source: SQLServerCentral.com | Category: substring
Rating: |  Discuss |   Briefcase | 544 reads

Union Forcing Distinct

The use of union would seem to force a distinct in each of the select statements being unioned. The use multiple unions, with mixed union and union all clauses, seems to cause haphazard results.  Read more...
By Clyde Merrell 2013/05/14 | Source: SQLServerCentral.com | Category: union
Rating: |  Discuss |   Briefcase | 589 reads

PowerShell to SlipStream SQL 2008

PowerShell script to SlipStream SQL Server 2008 installer with SPx patch.  Read more...
By Fahim Ahmad 2013/05/03 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 424 reads

Get IP Addresses of all Hostnames using SQL Server

To get the IP addresses of Multiple hostnames from below stored procedure.  Read more...
By Sumit Agarwal 2013/05/02 | Source: SQLServerCentral.com | Category: dba
Rating: |  Discuss |   Briefcase | 1,676 reads

PowerShell to search for domain Computer objects

Query Active Directory Computer objects to verify existence  Read more...
By Fahim Ahmad 2013/05/01 | Source: SQLServerCentral.com | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 466 reads

PowerShell to Pre-Create domain objects for SQL Server Cluster

Pre-Create Active Directory Virtual Computer objects to support a new SQL Cluster   Read more...
By Fahim Ahmad 2013/04/30 | Source: SQLServerCentral.com | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 249 reads

Script to find username and corresponding loginname for all user DB

Script to find username and corresponding loginname for all user database in SQL Server  Read more...
By Shashank Srivastava 2013/04/29 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 1,329 reads

Change DB Owner to sa for multiple DB's

Changes DB owner to sa for Online DB's where owner is not sa  Read more...
By Riken Patel 2013/04/26 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 771 reads

String Character Count

A while ago I once attended an interview where I was asked to write a short script that counts each letter of a given string.   Read more...
By Benson Sibanda 2013/04/25 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 1,047 reads

List of Stored Procedures modified in past 7 days

Provide list of Stored Procedures that have been changed in past 7 days.  Read more...
By Nitesh Dedhia 2013/04/24 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,393 reads

Check Candidate Columns for FOREIGN KEY Constraints

Reports table columns that are not foreign keys but that perhaps should be.  Read more...
By Charles Jacobus 2013/04/23 | Source: SQLServerCentral.com | Category: maintenance | SQL Scripts Manager Compatible
Rating: (not yet rated) |  Discuss |   Briefcase | 576 reads

Script to find the total used size of all database inside SQL Server

Script to find the total used size of all database inside SQL Server  Read more...
By Shashank Srivastava 2013/04/19 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,130 reads

Get Database Backup Details on SQL Server

DB Backup status Details   Read more...
By sathish siva 2013/04/18 | Source: SQLServerCentral.com | Category: backup / recovery
Rating: (not yet rated) |  Discuss |   Briefcase | 854 reads

Generate N numbers

Reursive CTE Script to generate n numbers  Read more...
By Harsha Majety 2013/04/17 | Source: SQLServerCentral.com | Category: recursion
Rating: |  Discuss |   Briefcase | 1,012 reads

Restore Latest Backup with Powershell

Restores the latest backup of a database to a destination server of your choice, and creates a new backup if needed.  Read more...
By Luke Losli 2013/04/16 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 637 reads

Tables in Merge Replication

Find all tables used in Merge Replication  Read more...
By Kishore Saripalli 2013/05/21 | Source: SQLServerCentral.com | Category: replication 2008
Rating: (not yet rated) |  Discuss |   Briefcase | 177 reads

Find the position of all occurrences of an expression within a string

This iTVF returns both the relative and the actual positions of ALL occurrences of a string within a string.  Read more...
By Steven Willis 2013/04/12 | Source: SQLServerCentral.com | Category: charindex
Rating: |  Discuss |   Briefcase | 707 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...
By Steven Whaley 2013/04/11 | Source: SQLServerCentral.com | Category: sql server | SQL Scripts Manager Compatible
Rating: |  Discuss |   Briefcase | 911 reads

Run SQL code on each database

You can use this to run a script/s on multiple databases  Read more...
By Ashley McLellan 2013/04/10 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,573 reads
   Items 1 to 20 of 2775    Next 20 >>
 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.