k cheers

will have a look at that.

The only thing is, i wasnt involved in either of these installs only involved with them after things went pear shaped.. i think  reinstall...

why is there a problem with the user creating there own Temptable.that is deleted once there application loses its connection?

yeah we have .

its happened on 2 clean installs of sbs2003. (2 seperate servers)

same setup that works on our win2k server dev machine

but no go.

k il take a look  tomorrow see wahts happening.

ive monitored cpu at diff times its not that as far as i can tell

disk and memory are where it may be getting stuck

waht would be good things to monitor...

that would be greatly appreciated

well are doing that now.

but its pretty inefficient as well as a pain in the ass to have change b/w either terminal server windows or to your desktop if installed...

also why would this have started all of a sudden.

It had been operating fine for like 7 months and then came to work one week and it had started to...

hmm well, its running like 2gb of ram

and has dual athlon processors.

It sucks so much, because we TerminalServ to the server for development, and basically if we install the sql...