How do I detect that my C# application has lost the
connection to the SQL Server. The reason for the lost
connection is that the network connection is down.
Changing the "connection timeout" property in the

I have a VB6 application working over a SQL Server 2000 database. since a
long time ago, I am experiencing serious performance problems, that I still
can't resolve. Normaly, the performance problems are related with database
design, query design, application design an hardware. ...

I am receiving General network error when I try to back up a SQL Server
database on a computer that is running Windows Server 2000
I receive Following error when running DB maintenance job:
[2] Database master: Database Backup...

I'm getting the following error when trying to connect to a Remote Server
I've set up:
Server 'Server_1' is not configured for DATA ACCESS.
I know this option is available with Linked Servers but I dont know what to

We are using SQL7 and are experiencing this problem when trying to update
to the database.  It is an intermitent problem.  Any ideas??? The error
code reads:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

We have a production database that has worked fine in many installations.
Several of our sites have larger databases with more activity and have no
problems. One rouge site has recently encountered a blocking problem that we
cannot explain.

What would be the best way to insert a string value with a ' in it.(like don't)?

Hi Group:
Hope this is the right forum...
Occasionally, when I write data to a linked Excel file from a varchar(50)
field, it arrives with a preceding single apostrophe (') in Excel. Doesn't

I have quite a few queries that I have written using Excel and MS query. I
basically connect to an outside ORACLE 8i  database and retrieve data for
analysis using Excel tools. I have been very succesful using this method, but
for some reason I am no longer able to 'Edit my ...

We have a program the connects to the SQL 2000 database and the program runs
on Windows Server 2003 Terminal Services, the issue that we are having is
that multiple process ID have been created (in our case its 4 process ID)
whenever the program connects to the database but when ...

The problem accured with the database that contains critical data, so it is
very important to me to solve it as quickly as possible.
So the problem is that I cannot attach my database to the SQL server.
How all this began? At first I decided to back up my database. But by

I got the following error when I tried to do a updateRow on a resultSet;
  SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Row update failed.
The error only occurs when the table name contains one or more high-bit
characters, e.g. ÀÉÎ.

I am using Microsoft SQL Server 2000 Driver for JDBC to connect to SQL
Sever 2000 (both application and sql sever are running on the same machine)
. It is just a test application to see if it would connect to the datacase
successfully. But I got the following errors. I already set ...

I had two databases on my server, and I just deleted the one which SQL Server
has identified as the default database.  Now I can't connect to the server
via SQL Enterprise Manager.  How can I rectify this situation?  The server
itself is not having a problem, I'm just not able to ...

I have a field in the query where I count the tech_area field.  I have an Iif
(Count Of([tech_field])=0, CountOf([id]),CountOf[tech_field]).
My question is how do I translate that in SQL Server?  I tried to write the
query using  the new view window but I kept erroring when I put ...