Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

Scripts by Gene Hunter

SQLServerCentral.com profile

Items 1 to 10 of 10

Database size trending with powershell

a script to import all database sizes from a list of servers into a table using powershell for trending purposes YOU MUST DOWNLOAD CODEPLEX SQL SERVER MODULE FOR THIS TO WORK. Read more...

By Gene Hunter 2012/06/13 | Source: SQLServerCentral.com | Category: powershell

Rating:

|

Briefcase | 1,231 reads

Script to find Disk Space including Mount points

works two different ways using sql for 2000 and 2005 and powershell for 2008. Read more...

By Gene Hunter 2012/05/23 | Source: SQLServerCentral.com

Rating:

|

Briefcase | 1,754 reads

PowerShell SCript to export almost everything from a list of servers

Create a c:\servers.txt list of servers. No spaces or it wont work. Then copy the code into a ps1 file and edit the directroyfilename to show where you want the files to end up. Read more...

By Gene Hunter 2012/02/17 | Source: SQLServerCentral.com

Rating: (not yet rated) |

Briefcase | 1,373 reads

Stored procedure to find and replace text in a text file

find and replace text in a text file using tsql Read more...

By Gene Hunter 2012/01/23 | Source: SQLServerCentral.com | Category: string manipulation

Rating:

|

Briefcase | 2,668 reads

create jobs script for 2000 2005 or 2008

will create jobs script for backup or DR purposes to install on another server. Read more...

By Gene Hunter 2012/01/18 | Source: SQLServerCentral.com | Category: jobs

Rating:

|

Briefcase | 1,780 reads

Save all DTS packages

short script but another way Read more...

By Gene Hunter 2012/01/25 | Source: SQLServerCentral.com | Category: dts

Rating:

|

Briefcase | 1,071 reads

Find storage including mount points Sql and windows utility

Find drive, freespace, usedspace and percent free for all drives and mounted volumes. Read more...

By Gene Hunter 2012/02/16 | Source: SQLServerCentral.com

Rating:

|

Briefcase | 697 reads

Find storage including mount points sql/powershell

Find all storage including mount points and show' free and used available. Needs powershell. Read more...

By Gene Hunter 2012/02/22 | Source: SQLServerCentral.com

Rating:

|

Briefcase | 583 reads

Move DTS packages to another server

easy way to migrate DTS packages to another server Read more...

By Gene Hunter 2012/02/07 | Source: SQLServerCentral.com | Category: dts

Rating:

|

Briefcase | 885 reads

poor mans archival of backup files and tran logs to alternate location

This script will backup your files that have changed only. old files will not be copied just newer ones. Read more...

By Gene Hunter 2012/01/17 | Source: SQLServerCentral.com | Category: backup archival

Rating:

|

Briefcase | 575 reads

Items 1 to 10 of 10