Skip to content

Instantly share code, notes, and snippets.

View 42degrees's full-sized avatar

Scott Gartner 42degrees

  • 42 Degrees Design
  • Boise, ID
View GitHub Profile
@wqweto
wqweto / sp_foreachdb
Created December 18, 2014 16:57
Replacement for sp_msforeachdb
USE [master]
GO
IF OBJECT_ID('dbo.sp_foreachdb') IS NULL EXEC ('CREATE PROCEDURE dbo.sp_foreachdb AS RETURN 0')
GO
ALTER PROCEDURE dbo.sp_foreachdb (
@command NVARCHAR(MAX),
@replace_character NCHAR(1) = N'?',
@print_dbname BIT = 0,
@print_command_only BIT = 0,