News, links, downloads, tips and tricks on Microsoft Access and related

About Me Search
Name:Alex Dybenko

Location:Moscow, Russia

Thursday, September 10, 2009

Querying All Databases With sp_MsForEachDb

If you need to query several databases on same SQL server – you can use undocumented stored procedure sp_MsForEachDb, see Scott Mitchell article Querying a Multi-Tenant Data Architecture for more info and execution examples.



Anonymous Data Entry Services said...

Thank you Alex.

9:48 PM  

Post a Comment

Links to this post:

Create a Link

<< Home