Category: SQL

  • How to drop many databases which share a common prefix

    I recently used AutoSPInstaller to deploy 2010 into a production farm. It provides a great way to automate and reproduce installations. As a great side benefit, it creates all SharePoint databases with the same prefix. After a few runs in a lab environment, I wanted to clean up old SQL databases. Using SSMS to delete […]