>Local temp tables are application or user specific - which means that they are only visible to the connected user. Also, the server usually drops them when the user disconnects. Could this be part of the problem in your environment?
>

No, Good idea. But the table is being created in one stored proc, and attempted to be filled in another stored proc by the first. So that isn't the problem, but a good idea.

Morgan