2017-01-30 (first published: 2017-01-26)
2,887 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)
13,423 reads
2010-09-08 (first published: 2010-09-02)
2,259 reads
2008-08-06 (first published: 2008-06-16)
1,376 reads
Blogs
Why do DBAs dislike loops?
If you started out as a developer you were probably taught how important loops...
Public and Demo Data Coming Soon!
Any database professional that has been around the Microsoft world for more than about...
New Centralized View of SQL Resources in Azure
Yesterday, some new views were made available in the Azure portal that will be...
Forums
Upgrade to SQL Server 2008 R2 SP2 from SQL Server 2005 SP3
Hello, I noticed that SQL Server 2005 SP3 is not in the in the...
Can't drop database in "restoring" state from secondary instance of AG
MSSQL version: 2016 (13.0.5026.0) Situation: Removed a database from an availability group so it...
ReportServer Database upgrade fails
I've tried several times to successfully migrate a SQL Server 2008R2 ReportServer and ReportServerTempDB...
Ask SSC