Gavin Campbell gavincampbell
gavincampbell
/ oops.sql
Last active
March 6, 2016 16:03
Transact-SQL script to drop all user-defined objects accidentally created in the SQL Server master database
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| DECLARE @dropStatements TABLE (dropStatement varchar(1000), dropOrder tinyint); | |
| DECLARE @dropStatement varchar(1000); | |
| INSERT INTO @dropStatements | |
| select | |
| CONCAT( | |
| 'DROP',' ', | |
| typename,' ', | |
| OBJECT_SCHEMA_NAME(object_id), | |
| '.', | |
| OBJECT_NAME(object_id),';'), |
NewerOlder