I have about 30 machines that I currently manage.  I should also say, I just
took over this position as Senior DBA.  One machine is a Windows 2003 Quad
Processor 4GB ram box with SQL 2000 Standard Edition installed.  I am in the
SQL Admin group and SQL is set for both SQL and ...

Hi, how to check how many connections current be used?
Thanks,

We have developed an application that use .NET 2.0 and in the same
server are installed the SQL server.
The problem is that when i use "LOCALHOST" on the application
everething works fine, but when i chage it to the IP number the

I'm building up a membership website by using MS SQL Express and
ASP.NET2.0 with IIS on Windows XP Professional. I've developed a login
page for the user to type the username and password to login.
Everything is ok when I use VS.net 2005 to do testing. However,I

Ok here is the problem.  I am trying to set up logging on SQL 2005.  Now I
am trying to setup the OBDC on the ISA server and it is failing each time.
It cannot reach the server.  Every other computer in the domain can access
the SQL server via OBDC.  So what am I missing to do ...

I completed a default install that uses the server name: Server1
and completed an instance install on Server1 called Server1test with
the same users, etc.
I can connect remotely to Server1 using SQL Server 2005 Management

Hope i have the newsgroup im going out of my mind.
I made a little ODBC client that fills in some data into a table, and it was
working fine, then i wanted to stresstest it, and then it showed the leak.
I have browsed allover, and i found this KB on MS, then i took my own little

I've got a windows 2003 server running sql server 2005. When I run a web site
on a desktop machine, there is no problem connecting to the database.
But, when I run the same web site with the same connection string on the
2003 server, I get the following error:

Does anyone know how the ODBC driver gets the application name that is
displayed by the SQL Server profiler? Our application does not explicitly
pass it in with the connection string but we are seeing a name under the
ApplicationName column in SQL Server profiler.

1. I have a SQL2000, SP3  Linked Server to an Access mdb that breaks every
couple of weeks.  If I do a SELECT statement to the Linked server in Query
Analyzer,, even on a small table of 3 records, QA seems to be working, and
no error messages come up.  However, the SELECT command ...

Hi,
I am using the SQL 2005 driver (1.1.1501.101) to create tables on a SQL
2000 server using an ant script.
I get this error sometimes:

We have one sql server 2005 machine which have two instance named:
DEVSQL(default server named when first installed) and DEVSQL\TESTING (second
installed).  On the client, I can connect default instance, but the second
instance cannot connect.  What settings I should to do?

I have just installed vista and reinstalled the SQL tools, but can not
longer connect to the SQL Server 2005 server.
I recall there where some diag nostic tools (sqlping ??) that could help
resolve connection issues (vista firewall is off) but can not find them.

I'm running Vista RC2, SS 2005 SP2 CTP, NetBeans 5.5 and JDK 1.6 Beta. I've
established the CLASSPATH variable in Windows and in the IDE. I've placed
sqljdbc_auth.dll in c:\Windows\System. I have three registered SQL Servers on
my desktop (imaginativly named DELL). The instances ...

i want to install sql server 2000 in my machine which has win xp. now the
problem is that it does not get connected to the server. error message comes
that there is a connection failure.
pls help me