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

Scripts by Shirley Bouzon

SQLServerCentral.com profile

   Items 1 to 6 of 6   
 

Modify All Database Data and Logfile Names

This script modifies all dtabase .mdf and .ldf to have a standardized name of DatabaseName_Data and DatabaseName_Log.  Read more...
By Shirley Bouzon 2011/08/08 | Source: SQLServerCentral.com | Category: logfile names
Rating: |  Discuss |   Briefcase | 906 reads

Find Job Names that Contain SSIS Packages and their Location

This will give you a list of jobs that contain SSIS Packages should you have a project in which you may need to review changes to Packages.  Read more...
Rating: |  Discuss |   Briefcase | 1,538 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,774 reads

Change Time Zone on Server without Logging on to Box

Sometimes logging onto a box for a simple change like this is not possible for the business. This allows you to change this directly from T-SQL without having to log on or RDP into the box.  Read more...
By Shirley Bouzon 2011/08/17 | Source: SQLServerCentral.com | Category: time zone
Rating: |  Discuss |   Briefcase | 423 reads

SQL Server Security Extract (Reverse Engineer) for ALL Databases

These scripts will extract security for Windows Logins, Database Users, Roles, Objects and SQL Logins.   Read more...
By Shirley Bouzon 2011/08/03 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 1,881 reads

Check DTS Package Logs for Errors

This will let you know which package had errors rather than sifting through all the package logs one by one.You just need to replace the date.  Read more...
By Shirley Bouzon 2008/06/23 | Source: SQLServerCentral.com
Rating: (not yet rated) |  Discuss |   Briefcase | 684 reads
   Items 1 to 6 of 6