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-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&hl=en
------------
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-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&hl=en
------------
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-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&hl=en
------------
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-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&hl=en
------------
Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke