SQLServerCentral - Scripts by Shirley Noa

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 Noa 2011/08/08 | Source: SQLServerCentral.com | Category: logfile names

Rating:

|

Discuss |

Briefcase | 861 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...

By Shirley Noa 2011/08/23 | Source: SQLServerCentral.com | Category: integration services (ssis)

Rating:

|

Discuss |

Briefcase | 850 reads

Get SQL Server IP Address

To Get Server IP Address without having to log into box or RDP Read more...

By Shirley Noa 2011/08/02 | Source: SQLServerCentral.com | Category: ip addresses

Rating:

|

Discuss |

Briefcase | 2,592 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 Noa 2011/08/17 | Source: SQLServerCentral.com | Category: time zone

Rating:

|

Discuss |

Briefcase | 400 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 Noa 2011/08/03 | Source: SQLServerCentral.com

Rating:

|

Discuss |

Briefcase | 1,651 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 Noa 2008/06/23 | Source: SQLServerCentral.com

Rating: (not yet rated) |

Discuss |

Briefcase | 673 reads