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 / restore

Rating:

|

Discuss |

Briefcase | 1,190 reads

Yet another restore script usp_restore

By Wesley Brown 0001/01/01 | Category: maintenance and management

Rating:

|

Discuss |

Briefcase | 538 reads

yet another backup script using litespeed or native backup

By Wesley Brown 0001/01/01 | Category: maintenance and management

Rating:

|

Discuss |

Briefcase | 879 reads

yet another backup script usp_backup

By Wesley Brown 2004/09/06 | Category: maintenance and management

Rating:

|

Discuss |

Briefcase | 269 reads

Capture SQL Logins

By Wesley Brown | Category: miscellaneous

Rating:

|

Discuss |

Briefcase | 1,189 reads

Get all user information at the database level

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

Rating:

|

Discuss |

Briefcase | 925 reads

alert on blocking chains via email

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

Rating:

|

Discuss |

Briefcase | 1,486 reads

Generate all user stored procedures in all dbs

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

Rating:

|

Discuss |

Briefcase | 383 reads

Proper Case User Defined Function

By Wesley Brown | Category: t-sql aids

Rating:

|

Discuss |

Briefcase | 316 reads

Backup Transaction Logs on all Databases

By Wesley Brown | Category: backup / restore

Rating:

|

Discuss |

Briefcase | 799 reads

Differential Backups of all Databases

By Wesley Brown | Category: backup / restore

Rating:

|

Discuss |

Briefcase | 1,490 reads

Stored Procedure to Backup all Databases

By Wesley Brown | Category: backup / restore

Rating:

|

Discuss |

Briefcase | 4,303 reads