First some background:
We've got this system at a client site running on Citrix with seperate data servers. This sometimes causes some crashes and this is leaving orphaned TMP files in our data directory that are locked and sometimes these locked files are crashing the system somehow.

Why its wierd:
We have our TMPFILES setting in the config.fpw set to a specific directory that is most certainly not our data directory. Were not changing it at any point in the application.

My best guess so far:
I havn't been able to prove it but I think a stored procedure that creates some cursors is to blame for these perticular temp tiles. I can't reproduce it however, so they remain a mystery at the moment.

Questions...
Has anyone experienced temp files created out of their designated location in an application because the database container is creating them?

Does anyone have good ideas for how to capture these temp files, aka under what conditions they are generaly created and how they could come to be locked.