close connection

  1. J

    what is relation between closing/disposing a sqlconnection, and the SPIDs in SQL with

    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...
Top
Sign up to the MyBroadband newsletter
X