I am looking for a definitive guide to set up a linked server in SQL Server
2000.
I want to add a linked server to an Access (95) database
I have managed this on our production server (although I keep getting errors

Users in remote building (On the same VLAN? Not sure of network specifics)
can connect to the sql server in the remote building with no issues. In my
building (HQ), we were able to connect to it until this morning. Last night
the domain controller in the remote building was upgraded ...

When trying to connect to 2 of my SQL Servers I am getting General Network
Error.  I have run Portqry against both of my servers and they both return
that ms-sql-s Sevice is listening on port 1433.  When I try running ODBCPing
I get the following results:

I'm getting this error in the SQL Server logs.  Can anyone give me any ideas
how I can begin troubleshooting this one?
WARNING:  Failed to commit contiguous memory of Size 65536.
Users are getting "insufficinent to memory to execute query" messages and

My app accesses a simple table (generated by a 3rd party tool) that has
a 'datetime' column.
My app needs to query for all rows in a specific date/time range.
The prepare text is something like:

I'm running Win/2003 Server, SQL Server 2000, and Sun Java 1.5.
MS article # 3323200 "How to get started with ms jdbc"  says I need to set
the CLASSPATH variable to point to my jdbc.jar file location.
Where do I go to make this setting.  Apparently it is not set like the PATH

Can I use a table variable to gain output using the sp_executesql procedure?
Example:
Normally I might have something like:
DECLARE @max varchar(9),@sExec nvarchar(200)

I thought I asked this question before, but I can't find it in the list so
I'm trying again.
I'm developing an application on Java JDSE 1.5 for Windows from Sun
Microsystems.  I need to connect and interact with an MS SQL Server 2000.

I have to gain exclusive access to a MS SQL Server 2000 Database from a VB
application through ADO for a very short period of time in order to do
special processing (data historization and computation) and preventing that
others users can connect at the same time. Which is the ...

The following is being attempted from the SQL Server itself via Remote Desktop.
If I try to set up a linked server via ODBC to data that is on another
server, I get an error stating that the server is unable to open the DBC
file. However, if I try to simply execute a DSN-less ...

Using VB .NET is there a way to return/track the reason why a connection has
failed to open.  I want to be able to track the following reasons for
failure:
1. User doesn't have the correct permissions set to open the database

Im getting this error when starting the Mssql server 2000
SuperSocket Info: Bind failed on TCP port 1433.
please advise
also note thta it is only  MSDE not the whole SQL Sever

Receive this error when starting SQL:  SuperSocket Info: Bind Failed on TCP
port 1433
SQL Error Log:
2005-01-12 16:01:35.78 server    Using 'SSNETLIB.DLL' version '8.0.766'.

I hope someone may be able to shed some light on my problem...
I am using as AS400 as a Linked Server from SQL 2000, and have been for 2
years or so, with good success, but I came across an issue this morning I
just can't solve.

If I select more than 1000 record from my FoxPro 5.0 database using
Query Analyzer or Enterprise Manager I get the following message: "Error
converting data type DBTYPE_DBDATE to datetime"
This is configured as a "Linked Server"