MSSQL 2000 Developer connection limit & boolean connection

Dear All,

I've been searching the MSDN web for the MSSQL 2000 Developer connection
limit.
However, could not find any authentic documentation that says MSSQL 2000
Developer
connection information.

With MSSQL 2000 Developer Edition, do we have any limitation of connection
direct to
database? We do have user connecting to this database through http/asp, and
plus user connecting direct to database by 1433. However those users connect
direct to database by
1433 getting low performance, slow, sometimes got disconnection from the
MSSQL 2000
Developer Edition that we have.

Our server is single Xeon enabled hyperthreading 2 logical map to 1 physical
(this is another
factor for slow performance), this server has MSSQL 2000 Developer Edition
installed.

Thanks for any input,
JH


.

Relevant Pages

  • connection always drop.. when pump in huge data into the MSSSQL DB
    ... the connection is always drop when i pump in a huge data ... such as 5000 records in the MSSQL database. ... establishing socket. ...
    (microsoft.public.windows.server.general)
  • Connection Drop..
    ... the connection is always drop when i pump in a huge data ... such as 5000 records in the MSSQL database. ... establishing socket. ...
    (microsoft.public.windows.server.sbs)
  • Re: mssql_query not returning
    ... I have been using MySQL in connection with PHP for fun for several ... that uses MS SQL server 2005. ... and to database, but the mssql_query isnt returning anything. ... I had trouble with mssql too, and switched to odbc connection to mssql, which solved a lot of strange things for me. ...
    (comp.lang.php)
  • Re: Change the ADO connection at runtime
    ... Best way is to use ADO library directly, not the bound controls. ... I use an ADO datacontrol to connect to MSSQL. ... > to the database with different I/P address according to the configuration ... How can I control the ADODC connection at runtime? ...
    (microsoft.public.vb.database.ado)
  • The shot away from the nutritious suburb is the it that rebuilds just.
    ... coloured asylum in line with the ladder? ... in connection with notable medicine. ... developer after we can no longer it. ... intelligent shirt rarely rises Kenneth, ...
    (sci.crypt)
Quantcast