Unanswered: Timeout Expired in Management Studio when opening and closing SPs
"Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached"
I get this error in management studio when I'm looking through SPs.
1. I open a SP
2. Check if I want to change the code
3. I close it
I have about 300 SPs to check, after a while I get this error. It seems like Management Studio is not closing the connections correctly.
If I run "sp_who2" I can see a lot of sleeping with my login.
All I have done is select "modify" on an SP and then closed the window it appeared in.
System information copied from Management Studio:
Microsoft SQL Server Management Studio 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
Microsoft Analysis Services Client Tools 2007.0100.1600.022 ((SQL_PreRelease).080709-1414 )
Microsoft Data Access Components (MDAC) 6.0.6001.18000 (longhorn_rtm.080118-1840)
Microsoft MSXML 3.0 5.0 6.0
Microsoft Internet Explorer 7.0.6001.18000
Microsoft .NET Framework 2.0.50727.3053
Operating System 6.0.6001