We are running a dedicated program that uses SQL server in an ad hoc
invironment between multiple laptops.  The OS is Windows 2K pro.
The problem we are having is that the SQL connection is being lost even
though the wireless connection is intact.

is there a util from Microsoft to test the sql server to find out how many
clients it can take w/o significant drop in performance?

I have users in domain group who use application which uses sqlserve, they
have rights to insert, update, delete. I want some of the members of this
domain group to connect directly to the database using query analyzer but
with right only to read and they still of course can use ...

Is only Help disabled or there are other problems???

executing dimension process, the system return an error :
- Cannot generate SSPI context"
I'm not understand where is the problem.....all config parameters are
correct....

Can anyone direct me to some whitepaper about tweaking SQL 2000 to have it
run optimally?
Thanks,

I cant connect my sql server by ODBC to some pcs with WinXP-SP1
Anyone know how I can accomplish this?
I have Microsoft SQL Server  2000 - 8.00.760 (Intel X86)
    Dec 17 2002 14:22:05

I am using SQLServer on my development laptop, and it's running without
any problems since at least 6 or 7 months. Suddenly, since yesterday,
when I start the Entreprise Manager, it takes absolute AGES (minutes,
with a very intensive disk activity) until it shows the console root ...

I have following questions regarding C#  Assembly and Threading.
Let me know the precise answer or lead me to the proper materials.
1.  Is memory leakeage possible in .Net Manager Code ?
2. Is memory leakage possible in .Net Unmanaged Code ?

Hi! I have a developer who reported the following problem
"For those of you who aren't familiar, the way we modify data in the Java
apps is through an API called JDBC. The JDBC API provides a
PreparedStatement class that allows you to assemble sql and then have it

I am trying to conncect to a SQL Server 2000 DB via a Websphere JDB
Provider.  SQL Server 2000 and Websphere are on different machines.  
performed the following steps:
1. Installed the SQL Server 2000 Driver for JDBC on the server wher

I'm getting Error 5123 "Cannot Open file because file is being used by
another process" when I try re-attaching a DB (.mdf) I had just detached.
I'm afraid I issued a DBCC command (which may be locking the file) right
before I detached the Database:  DBCC OPENTRAN (oldoaiapp)

I detached a database and moved it to another folder. I am trying to
re-attach the database and am getting 'Error 5123: CREATE FILE encountered
operating system error 32(The  process cannot access the file because it is
being used by another process.) while attempting to open or ...

When I used the MS Sqlserver 2000 jdbc drivers my java code that had the
following query worked fine...
the query looks like
IF EXISTS (SELECT * FROM sysobjects WHERE id =

I am able to run queries using the query analyzer. I have Enterprise Manager
but the SQL Server Group does not hold the SQL Server I need to connect to -
when I try to register the server, I am still unable to see the server in the
list of available servers - can somebody help?