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