The undocumented sp_MSforeachtable procedure

This posting demonstrates how to use the undocumented sp_MSforeachtable stored procedure in the SQL Server master database to execute a SQL script against each table in the database. Great for disabling check constraints before loading data.