Mike's Database Place

MSSQL Built-In Procedures

Databases

SQL Server

MSSQL Databases

sp_MSForEachDB

Example

exec dbo.sp_msForEachDb @command1='SELECT * FROM ?.sys.database_files'

Bibliography

sp_MSForEachDBhttps://www.sqlservice.se/sp_msforeachdb-tricks-of-the-trade/https://stackoverflow.com/questions/39336171/executing-sql-query-on-multiple-databases

Page updated

Google Sites

Report abuse