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,224 reads

Yet another restore script usp_restore

By Wesley Brown 2004/10/25 | Category: maintenance and management

Rating:

|

Discuss |

Briefcase | 568 reads

yet another backup script using litespeed or native backup

By Wesley Brown 2004/10/26 | Category: maintenance and management

Rating:

|

Discuss |

Briefcase | 922 reads

yet another backup script usp_backup

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

Rating:

|

Discuss |

Briefcase | 278 reads

Capture SQL Logins

By Wesley Brown 2013/05/22 | Category: miscellaneous

Rating:

|

Discuss |

Briefcase | 1,272 reads

Get all user information at the database level

By Wesley Brown 2005/03/30 | Category: miscellaneous

Rating:

|

Discuss |

Briefcase | 953 reads

alert on blocking chains via email

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

Rating:

|

Discuss |

Briefcase | 1,558 reads

Generate all user stored procedures in all dbs

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

Rating:

|

Discuss |

Briefcase | 394 reads

Proper Case User Defined Function

By Wesley Brown 2013/05/22 | Category: t-sql

Rating:

|

Discuss |

Briefcase | 325 reads

Backup Transaction Logs on all Databases

By Wesley Brown 2013/05/22 | Category: backup / restore

Rating:

|

Discuss |

Briefcase | 815 reads

Differential Backups of all Databases

By Wesley Brown 2013/05/22 | Category: backup / restore

Rating:

|

Discuss |

Briefcase | 1,497 reads

Stored Procedure to Backup all Databases

By Wesley Brown 2013/05/22 | Category: backup / restore

Rating:

|

Discuss |

Briefcase | 4,379 reads