2017-01-30 (first published: 2017-01-26)
8,303 reads
sp_msforeachdb
sp_msforeachdb: Improving on an Undocumented Stored Procedure
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!
2016-04-15 (first published: 2014-12-01)
14,453 reads
2010-09-08 (first published: 2010-09-02)
2,288 reads
2008-08-06 (first published: 2008-06-16)
1,692 reads
Blogs
Why I am running for the PASS Board in 2020
By HamishWatson
This blog post lists the reasons why I felt the need to run for...
Blog Refresh – Growing Readers
By gbargsley
Happy Tuesday everyone… In early 2017 I started blogging on this site in hopes...
Daily Coping 27 Oct 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
cannot find MSOLEDBSQL driver for SSIS 2019 connection manager
In the list of connection manager driver, I cannot find MSOLEDBSQL, There is a...
Lean Coffee
Comments posted to this topic are about the item Lean Coffee
How Long is the List?
Comments posted to this topic are about the item How Long is the List?
Ask SSC