This can be somewhat confusing when looking at sp_who in Query Analyzer.  I believe this is somewhat of an energy saver feature.  When a spid is sleeping it is simply holding a place holder representing a login against the database.  It is very common to see many processes with a status of sleeping even from Production application processes.  I do not believe these processes are holding locks nor do they affect performance.

Oh, btw, GO HOGS!

Cortec