Home Forums SQL Server 2005 Administering Query Multiple Databases RE: Query Multiple Databases
Database admin(DBA)
SSCertifiable
Points: 5373
More actions
April 6, 2013 at 5:10 am
#1604210
Hi,
please follow the link below for more information.
http://www.codeproject.com/Articles/459536/SQL-Server-Applying-Filter-on-sp_MSforeachDB
u can use sys.databases also.
Thanks&Regards,
SQL server DBA