Hey David,

You have to fire the guy that wrote that code! The "correct" way to write a service is to pull all that code out of the service and put it into a console application that can be debugged and traced easily. The only thing your service needs to do is Process.Start on the console exe. Let me know if you need some sample code.

As for the temporary table error in the sproc, just make sure the temp table doesn't already exist. Sometimes it sticks around from a previous debugging session and causes mayhem. Anyway, once you get it into a console app it should be easier to trace and debug.


>Does anyone have any idea what the problem is, if this is a bug, or even just the best way to debug and trace services? Any suggestions would be appreciated.

"The Original Dave"