I've been tasked with investigating different methods of achieving database
redundancy.
In doing so, I'm currently in the process of writing a test application to
prove that Database Mirroring in SQL Server 2005 is a suitable solution.

I'm new to UNIXodbc but I would like to find a simple example of a row
returned from a select
This is my code
long fnum;

If I understand correctly, Enterprise manager has been replaced with SQL Server 2005
Express?
Can I use SQL Server 2005 Express from my desktop to connect to an SQL 2000 database on
the internet?

I Have SQL Server 2000 local installed on a Windows XP SP2 machine,
Dutch version.
SQL Server first connected fine via the default settings 'Use Windows
Authentication'. I use it to test VB.Net practices, which went fine

I have installed SQL Sever 2005 on an x64 bit machine running Windows 2003.  
When I go to the ODBC Data Source Administrator, and click on the Drivers
tab, it only shows:
SQL Native Client

I have come across the following problem using the SQLServer 2000 JDBC
drivers. We need to execute a stored proc on SQLServer, from within a
J2SE app (Java 1.4). We are using a CallableStatement to execute the
stored proc, however, unless we turn on implicit transactions within

How can I change the Connection String programmatically?
(WS2005, Windows forms, C#)
I need to change the server name, or Initial Catalog parts of the string.
My connection strings are in a field of a master SQL database table.

On my development maching, I have three different SQL Server instances:
.\SQL2000
.\SQL2005EXPRESS
.\SQL2005

We are still having issues running maintenance plans on a server since
joining a large domain.  Error message for the backup job follows:
The job failed.  Unable to determine if the owner (DomainName\sa-stpisap) of
job DB Backup Job for DB Maintenance Plan 'DailyMaintenancePlan' ...

In order to stop some occasional blocking issues could I set the "query
execution time-out settings" to 30 seconds for example. I understand it will
kill the queries that exceed 30 seconds, but I would rather have that then to
have everyone "lockup". I also understand that ...

I was given this one. Right now I am familiar with how to do this in Access,
but SQL Server is what I need to use.
What does one have to do to connect SQL Server (right now 2000, but soon
2005) to a FoxPro free-table directory?

We installed the JDBC driver on our Dev server after converting our database
from SQL 2000 to SQL 2005.  We are trying to index one of our pyramids in
Mercado and the JDBC driver seems to be accessed fine I believe but the SQL
Query Fails. In the Mercado logs I see the following:

Error:
[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
After trying all from Microsoft KB 313178, I'm asking here.
Application information:

Hi Folk
Can you tell me how I can connect to an SQL server using a vbscript?
Basically, I want to do the following:
..define array of sql statements (e.g. select * from customers,

I am attempting to attach an .mdf to SQL Express using "AttachDBFilename" in
the connection string, and I have a few questions on the issue.
I am planning on setting this up on a network with both the .mdf and the
instance of SQL Server residing on a server.  All the clients will ...