I am trying to troubleshoot a SQL Server connection from my home machine
to an instance of SQL server running on my client's network using
Enterprise Manger and I am going through the steps in the MS KB article
How to troubleshoot connectivity issues in SQL Server 2000,

I can be connected to services analysis 8.00.194 through HTTP?

Users on the same PC who do not have admin rights cannot see or logon to the
sql server/msde that exists on the PC.  Any user with admin rights can see
it, of course.  I have waded thru lots of hits in my searches but none of
them describe this behavior and whether I can surmount ...

Hi..im trying to use BCP to transfer data from text file to a SQL table and
give me an error. I have access to the db table with the 'sa' user and both
input and format files are in the directory. This was working well, but
suddenly stop working.

Websphere application for nurses license renewal application that hits our SQL Server 2000.
This was the first error that we decided to stop and start the application:
Unable to load SQL Server Data Driver driver.
Unable to create database connection.

If another sql server has my server registered is there any way for me to
find out?

I have some data that I want to select with an ORDER BY statement and be able to have it sorted in a hierrarchical order.
There will be essentially 1) and ID, and 2) a ParentID.
I would like to have the data returned sorted such that any row with a ParentID = to an ID is under that ...

I want to grant login for whole domain and then add certain domain
users to certain user defined sql server database roles.
I'm using SQL Server 2000.
1. I have created login for my domain user using Enterprise Manager (group

Can you help with this problem. I use SQLSERVER 2000, sp 3. When I keep
connection alive during
execution several ( a lot of ) queries I see that some connections do not free
memory ( I check memusage in sysprocesses ) . And as a result the total

I'm a SQL Server DBA, doing some profiling and tuning on a SQL Server
database that is being accessed by a JDBC Driver.
I am often seeing statements executed in the format of:
Select Field1, Field2, Field3, * From TableA

I have a webserver with sql server on it.
All was working fine until a few days ago, when now sometimes it refuses asp
a connection.
In other words, I have an asp page which accesses the database, but

I am developer and not db admin.
My boss wants that his clients would have possibility to use SQL Mail without installing MS Exchange or any mail server.
I.e. using webmail.
I configured and tested POP3 client (MS Outlook) to use

I have a server in my office which is configured as a linked server on
another one.
How can I configure the connections between them to be killed after a period
of non-useness. As the connections are not killed after some time the limit

I need to know if I can call up my sql server as a web-portal.
Thank you.

I have a java application running with JDK 1.3.1. I`d like connect this
application through the SQL DB ( MSDE + SQL Server 2000 Driver for JDBC
Service Pack 3, both are free ). Is it possible.
Txs in advance,