sp_msforeachdb

sp_msforeachdb: Improving on an Undocumented Stored Procedure

  • Article

Have you ever wanted to run a query across every database on a server with the convenience of a stored procedure? If so, Microsoft provided a stored procedure to do so. It’s unreliable, outdated, and somewhat obfuscated, though. Let’s improve on it!

4.71 (42)

2016-04-15 (first published: )

13,882 reads

Blogs

Code from Redgate Streamed

By

I presented a session today at Redgate Streamed and did a number of demos....

Daily Coping–2 Apr 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...

Learn SSIS and ADF for Free

By

It’s not from SQLServerCentral, though I hope to do more training across the next...

Read the latest Blogs

Forums

https //teespring com/instalift-cream-reviews-uk

By donnahinrichs

<!--more--> Instalift Most women at age 50 and above take care of gain weight...

Job failed

By ramyours2003

We migrated jobs from sql 2012 to sql 2019 , one  of the job...

Nike Air Max 270 React ENG Photon Dust Coming Soon

By stevenrowe98

has just dropped a brand new “Digital Pink” colorway of the Blazer Mid as...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers