I have found several SQL instances with RTM in my environment.  I would like
to get them up to SP4.   Any gotchas?  Do I need to apply previous Service
Packs, before I install SP4?

I Have SQL Express installed on 17 ships. Each ship has a VB6 Client
application using OLEDB to connect to the database on local machine. Other
workstations on network also connect - we think without error. The error
above is thrown on 4 of the 17 ships. The workstations acting ...

I am trying, without success, to obtain information from
the Active Directory using a linked server. I've trawled
the internet and found abundant information (including
others with a similar problem) but as yet no solution.

Trying to get a Vista PC to connect to the SQL Server 2005 Express on another
Vista PC.  The PCs do have access to each other.  The PCs can access the
shared folders from each other.  Both PCs can ping one another.  The SQL is
the only item that does not allow access to.

I am running a VB application which makes connection to the SQL server
database using DSN connection using ODBC. This application pulls data using
stored procedure.  The application does not insert / delete / update data.  
The application was working fine since it has been ...

First of all, excuse me for my very poor english : I just "speak" a bit of
english...
We recently have a problem with some PCs and ADO : we can connect our
programs to databases (SqlServer 2000 or Express 2005) via ADO.Net or ODBC,

Hi every body,
Im using VB 2005 to create a program that open SQL Data base
The problem that i want to detect the tables of a database
so how can i know a data base tables instantly

Is it possible to trigger a .EXE program to run on a Row insertion ...
I want to run an .EXE program whenever a new row is inserted to create a
directory somewhere on the server.
I know that there are triggers that I can use but these seem to be to

On my machine I have installed both SQL Server 2000 as SQL Server 2005.
On another machine SQL Server 2000 is installed.
I am able to connect to my local SQL Server 2000 Engine from within both
Enterprise Manager as SSMS.

During an asp.net page execution, is there a way to find number of open
connecions or current query being executed? etc etc.
Thanks,

I am not a SQL person but was asked to work on it.  The problem I am having
is that I cannot connect to the SQL Server unless the old computer is
running.  I have transferred all the settings and files to the new computer
and am able to run the sqlomgr.exe.  But it will not stay ...

Hi
I am new to SQL server and ODBC. I am trying to retrieve SQL server database
using VC++ (using VS.net).  I am using SQLConnect to connect to the SQL
server. My code contains

            I have SQL 2000 and SQL 2005 Express installed on my XP Pro
machine.  I have VMWare running a 2003 Server session as I have something
that I need to run to test the customers environment.  However, I cannot
connect to SQL Server 2005 from the VMWare session.  I can ...

How Can i distrubute my ODBC DSN record to my domain computers?

I am using SQL server 2005 with multiple client databases with the identical
structure.  Is it possible to disconnect from one database and connect to
another within the same ACCESS 2007 project?  In Access 2007 connecting to
the database through an ODBC connection (with linked ...