Share via

SQL Iterators - Making the life of the DBA that much easier

  • Article

There are several undocumented stored procedures that many DBAs rely on to do their day to day work - namely spMSForEachDatabase and spMSForEachTable. This project is a SQL-CLR assembly that provides equivalent functionality to those two stored procedures.

These stored procedures support pre and post commands, as well as up to three commands to be executed for each iteration (either databases or tables).

Complete examples can be found in the help file that comes with the project.

Additionally, all strings have been created as resources, allowing for easy localization.

The SQLIterator project can be downloaded from Codeplex here.