I'm trying to connect to my sql database across the internet from a C#
application. I am attempting to login using the administrator account that
has been added to the SQL server database and given all the roles. The auth
mode is mixed (it was windows, but I changed it to mixed ...

I need to copy my SQL Server 2000 database from my development machine to
the server of one of the client. By using Enterprise Manager I was going to
detach db from my server, create a database with the same name on a new
server, detach it, replace files on the new server with my ...

I'm having a problem with backing up SQL to a network share, often I would
get the "network name is no longer available".  Sometimes it works and
sometimes it doesn't.   During the backup, both servers - source and
destination are at minimal cpu , memory and network utilization.  ...

Is there a JDBC Driver for SQLServer 7 available?

Have testet the new JDBC sp3 from MS, and is now getting the following
errors, which I have not seen with older versions (sp1 + sp2).
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Connection
reset by peer: socket write error

how do I test if a certain field in a resultset has a null value.
I tried the following:
if  (r.getString("field") == null) {
}

Good Day,
Windows Server 2003 accessing SQL 2000 on another server in the network:
SQL Server is running great! Windows 2003 is running great! However, every
day, sometimes twice a day, the connection from ASP and ODBC to the SQL

I've had some problems connecting remotely to my named instance of SQL
Server, so I started some usual troubleshooting.  My original problem
was that I can run EM locally without problems, but not remotely.
After the usual checks I could think of I am down to this peculiar

Any clues why this exception is being reported when a weblogic ejb tries to
execute a stored procedure on the MS SQL servers?
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Broken pipe
       at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown

I found that I can only use name pipe to connect to the sql server.
When I use tcpip, it fails to connect.
I am sure I have enabled the TCP/IP protocol in SQL server
What causes it?

  Sometimes when i use my application but suddenly the
sql server disconnected and i find out that my query
become very slow.
  Can i check with you, how to detect  the connection

We are using Windows XP,
ADO.NET in our application (programming language: C#),
MS SQL Server 2000.
The computer is a SONY notebook.

If I prepare the following statement:
SELECT zA."ID" AS fA_A
, zA."IDFirma" AS fA_B
, zA."Name" AS fA_C

Please can somebody help me.
I am developing a VB6 application connecting to a SQL Server 2000
database,
which at the moment is on my local machine.

Can someone tell me if there is a way to link an MS SQL Database to a table
on an iSeries server?  There's some data I would like to read from a DB2
server, but I'm not sure how to access it through a Windows 2000 system.
Can MS SQL Server link tables like MS Access?