theres a lot of talk on the net, do you have to dispose a sqlconnection in each procedure? this is not that debate.
my question is: what effect does closing/disposing a sql connection have on the amount of sleeping SPIDs when
you execute sp_who2 on sqlserver?
e.g. if i have a...