ianyates:

Good point. Placing the code that forces recompilation in its own SP should reduce the time spent to recompile.

Robert W. Marda

SQL Programmer

bigdough.com

The world’s leading capital markets contact database and software platform.