You can't do LOCAL ALL LIKE t*. You'll get a syntax error. Also, if you have called procedures that rely on a PRIVATE variable from a calling procedure, you'll get errors because the variable won't be found.
>I have an application with many, many procedures and ALL of them issue this command. Would it be worth my effort to change these to LOCAL. The app is very speed sensitive.
>
>Robert
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer