SQLServerCentral - Scripts by Wesley Brown

Generate CREATE DATABASE FOR ATTACH for all databases on server

I couldn't find a solid script for this so I put this together. It creates the database EXACTLY as it was with growth and proper file groups. Read more...

By Wesley Brown 2008/12/18 | Source: SQLServerCentral.com | Category: Backup

Rating:

|

Discuss |

Briefcase | 991 reads

Yet another restore script usp_restore

By Wesley Brown 0001/01/01 | Category: Maintenance and Management

Rating:

|

Discuss |

Briefcase | 248 reads

yet another backup script using litespeed or native backup

By Wesley Brown 0001/01/01 | Category: Maintenance and Management

Rating:

|

Discuss |

Briefcase | 484 reads

yet another backup script usp_backup

By Wesley Brown 2004/09/06 | Category: Maintenance and Management

Rating:

|

Discuss |

Briefcase | 200 reads

Capture SQL Logins

By Wesley Brown | Category: Miscellaneous

Rating:

|

Discuss |

Briefcase | 788 reads

Get all user information at the database level

By Wesley Brown 0001/01/01 | Category: Miscellaneous

Rating:

|

Discuss |

Briefcase | 760 reads

alert on blocking chains via email

By Wesley Brown 2004/09/01 | Category: Miscellaneous

Rating:

|

Discuss |

Briefcase | 784 reads

Generate all user stored procedures in all dbs

By Wesley Brown 2004/08/31 | Category: Miscellaneous

Rating:

|

Discuss |

Briefcase | 302 reads

Proper Case User Defined Function

By Wesley Brown | Category: T-SQL Aids

Rating:

|

Discuss |

Briefcase | 231 reads

Backup Transaction Logs on all Databases

By Wesley Brown | Category: Backup / Restore

Rating:

|

Discuss |

Briefcase | 707 reads

Differential Backups of all Databases

By Wesley Brown | Category: Backup / Restore

Rating:

|

Discuss |

Briefcase | 1,403 reads

Stored Procedure to Backup all Databases

By Wesley Brown | Category: Backup / Restore

Rating:

|

Discuss |

Briefcase | 3,759 reads