sp_msforeachdb

SQLServerCentral Article

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!

(43)

You rated this post out of 5. Change rating

2016-04-15 (first published: )

16,935 reads

Blogs

Enterprise AI Operating Rhythm – Top 5 practices for 2026

By

2025 exposed a growing gap between AI ambition and operational reality. As budgets tightened...

Stop Being Surprised by Your Azure Bill: Use Budgets

By

When organizations migrate workloads to Azure, the focus is usually on architecture, performance, and...

Resetting on the AI hype train

By

There's a great article from MIT Technology Review about resetting on the hype of...

Read the latest Blogs

Forums

Celebrating Tomorrow

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Celebrating Tomorrow

SQL Art: I Made a Christmas Card In SSMS

By tedo

Comments posted to this topic are about the item SQL Art: I Made a...

lookup error

By support@omniverter.com

I am using ssrs in visual studio 2022, I work on a report, there...

Visit the forum

Question of the Day

Celebrating Tomorrow

Which of these is more appropriate for tomorrow?

See possible answers