try this Select @@MAX_Connections as Max_Connections luke On Fri, Jul 2, 2010 at 5:51 PM, wesley kirinya <kiriinya2000@yahoo.com>wrote:
If you want good help, u need to give us clearer, technical answers, unless u wanna pay.
What's your setup? What makes u think it's No. 2?
There could be other reasons for your problem.
8~)
--- On *Fri, 7/2/10, morris mbogo <moresmobuff@yahoo.com>* wrote:
From: morris mbogo <moresmobuff@yahoo.com> Subject: Re: [Skunkworks] SQL Issue To: "Skunkworks Mailing List" <skunkworks@lists.my.co.ke> Date: Friday, July 2, 2010, 5:19 PM
running on Win2003server, how do i know if its No 2 and how do i remedy the same?
thanks guys
--- On *Fri, 7/2/10, wesley kirinya <kiriinya2000@yahoo.com>* wrote:
From: wesley kirinya <kiriinya2000@yahoo.com> Subject: Re: [Skunkworks] SQL Issue To: "Skunkworks Mailing List" <skunkworks@lists.my.co.ke> Date: Friday, July 2, 2010, 8:53 AM
A. Check the log. 1. How many users are connecting to it? It could be reaching a connection limit. 2. The application code that accessed the server might not be closing already used connections, and more connections are requested before the abandoned connections time-out. 3. What OS is it running on? Non-server versions have a small network connection limit on the OS (not on the database).
O_O
--- On *Fri, 7/2/10, morris mbogo <moresmobuff@yahoo.com>* wrote:
From: morris mbogo <moresmobuff@yahoo.com> Subject: [Skunkworks] SQL Issue To: skunkworks@lists.my.co.ke Date: Friday, July 2, 2010, 7:34 AM
Hi nice people,
am using SQL 2008 on the network. why would it keep on disabling connection to users "randomly ", its irritating.
I & I
-----Inline Attachment Follows-----
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Server donations spreadsheet
http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1f... ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-----Inline Attachment Follows-----
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Server donations spreadsheet
http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1f... ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-----Inline Attachment Follows-----
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke <http://mc/compose?to=Skunkworks@lists.my.co.ke> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Server donations spreadsheet
http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1f... ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Server donations spreadsheet
http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1f... ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke