I seem to remember that this was an issue with the ODBC driver. There's an option to convert queries to temporary stored procedures - or something like that.
-Mike
>We have three SQL SERVER. One is 7.0. Two are 6.5. In one (only one) 6.5 the temp SP files created by Costpoint (an accounting application) are there forever. I don't know why. When you reboot the server, all temp SP are cleared.
>Because we can't upgrade this server to 7 or 2000 now, I plan to install Server pack 5a for this server first to see what will happen.
>
>
>Thanks
>
>
>Jim