2017-01-30 (first published: 2017-01-26)
12,257 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,443 reads
2010-09-08 (first published: 2010-09-02)
2,315 reads
Search for a Table in all databases
This Script can be used for searching a Table in SQL server 2005
2009-08-04 (first published: 2009-07-18)
1,068 reads
2009-04-28
2,347 reads
Using SP_MSForEachDB and SP_MSForEachTable - SQL School Video
In this new video, learn how to loop through your databases and tables. MVP Andy Warren shows how some system stored procedures included by Microsoft can push out the same code to a group of objects.
2009-03-26
4,515 reads
2008-08-06 (first published: 2008-06-16)
1,990 reads
RE: Question of the Day for 27 Dec 2004
Actually the Name property is read-only. The second line will fail. See BOLServer.Name Property :Public ReadOnly Property Name() As StringOther lines in the script will work fine. The explanation is correct, you do need a wrapper. Microsoft did it for you So just run a script.SeeCOM Callable Wrapperhttp://longhorn.msdn.microsoft.com/?//longhorn.msdn.microsoft.com/lhsdk/ndp/cpconruntimecallablewrapper.aspxYelena
2004-12-27
1 reads
RE: A complex problem
Goce Smilevski - Thanks for you reply and you are right the Output_Reaging value for Start_Time (12/21/2004 2:56:45 PM) be 105.
2004-12-23
2004-05-25
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers