sp_compilation_validation.ps1

$server = "localhost";					# The SQL Server instance name
$database = "MyDB";					# The database name
 
# Load the SMO assembly
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SMO") | out-null
 
# Create the SMO objects
$srv = New-Object "Microsoft.SqlServer.Management.SMO.Server" $server;
$db = New-Object ("Microsoft.SqlServer.Management.SMO.Database");
 
# Get the database
$db = $srv.Databases[$database];
 
# For each stored procedure in the database
foreach($proc in $db.StoredProcedures)
{   
    # NOTE: my stored procedures are all prefixed with "web_"
    if ($proc.Name.StartsWith("web_"))
    {    
        $proc.TextBody = $proc.TextBody;
        $proc.Alter();
        Write-Host "Altered " $proc.Name;
    }   
}