I have a stored procedure I wrote:
CREATE PROCEDURE spCreditCheck
@MatchID integer, @Price numeric, @RepSC numeric, @Rep2SC numeric,
@DeskSC numeric, @CheckResult numeric OUTPUT

Windows 2003,sql server
How can i connect sql server 2000?
Unable to get a linked server working.
Please help me,thanks

I have a 2003 server (completely up to date according to the windows update
utility) running SQL Server 2000 SP3a.  I have an ISAPI DLL which uses ADO
to connect to the database.  When I run this through my web site (IIS is
also on the same 2003 box),  about 50% of the time it work ...

sir,
kindly solve the error.When I do a database updation in the
ejbcreate function the driver is working properly but when
I tried to use a user defined function I am thrown an the

After I installed XP SP2 on my computer, I can no longer
connect to the SQL Server on my computer through the JDBC
Driver. The error I got is:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver

I we are using VFP & SQL2000 together.  At one clients office we are getting
problems with data storing "Null" values in about a dozen different columns
in 4 different tables.  I did some research and realized that when we
reinstalled the server we skipped putting SP3 in place.  ...

Hello I am trying to write a large java unicode character stream to an nText
column in a Sql Server 2000 - 8.00.534 (Intel X86) SP3 database with the
latest JDBC Type 4 driver SQLServer 2.2.0040.
I'm getting a Transliteration failed exception in my customer's environment

On Windows Server 2000 with SQL 2000 SP3 I opened a Query
Analyzer window to insert a single record into a remote
table.  This remote table is on SQL 2000 SP3 on Windows
Server 2003 Standard.  I insert a record with

I've just installed Visual Studio 2005 and SQL Server 2005 Express beta 2
(all on my local PC). I try to connect to the SQL server from studio using
"Tools/Connect to database" selecting my local pc in the "Select or enter a
server name" combo box. I can select my pc's name but when ...

Can anyone give me an example of the arguments for using openrowset to
connect to a text file data source?
Thanks,
Gerald

I have just read about the Call-level interface, a library of DBMS
functions that can be called by an application program.  Where can I
read more about the CLI function, Google & MSDN searches didn't yield
much and no examples etc.  Does any one actually program to this to

I have SQL Server 2000 with Pervasive SQL 2000i attached
as a linked server. When I run the following...
UPDATE OPENQUERY(LINKEDSERVER, 'SELECT "START_ORDER_NO"
FROM "OECTLFIL" WHERE "FILE_KEY" = 1')

I have had a problem with EM being extremely slow. The first time this
ocurred it was related to one users Windows Logon Profile... i.e. whichever
PC he logged onto, EM was very slow to connect and run. It turned out his
Windows Network roaming profile was corrupt and fixing this ...

Hi friends
when i try to connect our sql server thru QA or EM i am getting timeout
expired.
It happens intermittently.

Not sure if this is the right forum, if not, please
direct me.
When I create a link to a SQL 2000 server database via
Dreamweaver MX, for some reason on one account retrieved,