SQL Clone
SQLServerCentral is supported by Redgate
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 | 938 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,672 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,962 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 | 437 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 | 2,080 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 | 695 reads
   Items 1 to 6 of 6