2017-01-30 (first published: 2017-01-26)
13,711 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)
15,747 reads
2010-09-08 (first published: 2010-09-02)
2,322 reads
2008-08-06 (first published: 2008-06-16)
2,164 reads
Blogs
Daily Coping 20 Mar 2023
By Steve Jones
Today’s coping tip is to get outside and notice how the weather feels. This...
Tales From The Field Weekly Wrap Up for the Week of 03-13-2023 & SQLBits 2023
By SQLBalls
Hello Dear Reader! What an incredible week we had. I started off traveling on...
Enjoying SQL Bits
By Steve Jones
It’s been a good week at SQL Bits. This is my favorite conference, and...
Forums
Bcp queryout issue
Hi all, I am running the following query in SQL, trying to export some...
SQL Server RLS Database Users and Login User Permission
Please suggest practice on SQL Server RLS On the database level, defined users with...
SSIS connection manager password update
Hello, I have 3 SSIS packages having connection manager defined with a userA. These...
Ask SSC