Current Activity-->Process Info in Enterprise Manager. If you see a lot. Double-clicking on each activity will tell you the last command that was run. If you see a lot of activities with the same command listed, search your code for references to that command. If this is the case, Most likely, you are forgetting to close the connection somewhere. "Swanand Mokashi" wrote in message news:u$0gYIUVDHA.2224@TK2MSFTNGP09.phx.gbl...[quote] > Are you using the same user name and password to connect to SQL Server (I > assume) , everytime you connect ? > If not you are NOT using the advantages of connection pooling. > -- > Swanand Mokashi > Microsoft Certified Professional > [url]http://www.swanandmokashi.com/[/url] > Home of the Stock Quotes, Quote of the day and Horoscope web services > "Trevor Hartman" wrote in message > news:O1mATEUVDHA.2192@TK2MSFTNGP10.phx.gbl...[quote] > > Hi, > > > > Every now and then (once a week maybe), I get this error on my page[/quote][/quote] saying[quote][quote] > > Timeout Expired. The timeout period elapsed prior to obtaining a[/quote] > connection[quote] > > from the pool. This may have occurred because all pooled connections[/quote][/quote] were[quote][quote] > > in use and max pool size was reached. I don't know anything about > > connection pooling, but could someone give me a suggestion on how to[/quote][/quote] take[quote][quote] > > care of this? It usually goes away by itself eventually, or I just[/quote] > restart[quote] > > IIS. > > > > Thanks - Trevor > > > >[/quote] > >[/quote] [allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => [ref] => [htmlstate] => on_nl2br [postusername] => Mark Heimonen [ip] => markh@adiaim.co [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 4 [attachments] => [allattachments] => ) -->