I have created a stored procedure wich queries a linked ORACLE database. When
I try to save the procedure I get the following error
Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be
set for the connection. This ensures consistent query semantics. Enable ...

I have an Access 97 database (using Jet 4.0) connecting to a SQL 2000
via ODBC - the OS is Win XP Pro SP2.  When i open a form to display the
records in the linked table they come up fine, but after about 30
seconds it dings and i get the pop up ODBC--call failed.  If i close the

SQL Server 2000 on Windows 2000.  
Is this possible.  I try to create a new backup device and the only thing I
can locate is the local partitioned drives.  I try to put in a UNC and it
does not work.  

I need to store Japanese characters in SQL Server 2000 from a Java app, but
as I understand it, SQL Server 2000 does not support UTF-8.
What is the best choice for the column when creating the table (VARCHAR,
VARCHAR2, etc.?) and what is the best encoding when writing to the ...

BlankSometimes, when large tables are being queried via the MMC in  Enterprise Manager, an error is returned because of an SQL ODBC driver time-out.
The same query when run from the Query Analyzer is completing successfully. Is there a parameter that can be modified to increase ...

I have a question.
Maybe You know the equivalent to command LIMIT from MySQL
I couldn`t find something like this in MS SQL
PS

Hi, I have a client who is conneting to my server from theirs via a linked
server they've set up.
They perform the following query:
DECLARE @abcid int

Can someone point me to documentation related to the number of connections a
database can have before there is a degradation in the connection?
I was told that if you have a database on a computer with a Windows 2000
operating system you can only have 5 connections to the database ...

using SQL Server 2000 SP3a, and JDBC driver SP3 (Version 2.2.0040), and
SelectMethod=cursor I keep on getting the following during
Connection.commit():
   java.lang.ArrayIndexOutOfBoundsException

The error message that i get is: PROVIDER CANNOT BE
FOUND. IT MAY NOT BE PROPERLY INSTALLED.
When i run the same connection from the server to the
application installed on the server it works fine.

I have the following situation: I have a database on ServerA and a database
on ServerB. My client app connects to ServerA and uses a stored procedure to
retrieve a dataset from both ServerA and ServerB.
While developing the app (using SQL 2K Dev on my workstation), I used a

As we know,SQL server listens on port 1433 by default. Is there any
dependency between client and SQL server for this port number?I mean, how
will know the client that on which port the target SQL server listens?
Suppose I change this port number to 1533 and restarted the SQL ...

Enterprise manager for SQL Server 2000 gives the following
error, when trying to add a operator, job and alerts to
the SQL Server Agent...
Microsoft SQL-DMO (ODBC SQLState: 42S22)

my SQL Server version is 2000
How to register New Sql Server with local machine?
and how to connect?

Somehow, on my XP box, when I installed SQL Server 2000, I have only a named
instance running (and no default instance).
So, I have these ASP.NET applications that have "web.config" files that are
trying to connect to "localhost".