we see a strange behaviour after installing SP4 (under WIN2000).
On preSP4 environment everthing works well and as expected.
There is a (very simple) task:
Select a single one row, accessed by a defined 2-part-key, * with lock*.

I need to change the server name of a live SQL server. Aside for re-creating
ODBC connections; are there any issues doing this?

       In My SQL 2000 (w/ Sp4) it wont start sql service ( Win 2000 with
SP4 )
- Priya

I am trying to run SQL Server Enterprise on AMD Opteron 64-bit server
(Windows 2003 standard).
It is starting OK with no errors in event log, and I can work with it on the
same machine, but it's not opening any sockets,

I'm trying to connect a mobile computer runing under windows CE to a
database located on a windows XP desktop.
The mobile computer application is written in C# under Visual Studio .NET
2003.

I'm trying to connect to a SQL server in a standalone domain.  I'm using
Windows Authentication.  So when I connect it's throwing the domain for my
machine in there.  Is there a way to add the other domain to the connection
some how?

The application that I am working on uses a database to store
application-specific data. The choice of database server is defined by
the customer via ODBC settings.
The problem that we are running into is that the table name syntax is

I have a VB6 application that connects to an SQL2000 database on another
machine.  I'd like to be able to determine if the connection is still good
without having to close and re-open the database and check the error status
of the open command.  The state property of the ...