We recently upgraded our SQL 2000 SP3 instance (running on Windows 2000) to
SQL 2000 SP4 running on Windows Server 2003 SP1.  The migration went fine
but we are now experiencing a problem where connections are not dropping
once the application is finished with it.  The ...

We have two physical sites - A and B - and each has its own Domain.  Within
site A's domain, we created a link server and everything works just fine.  We
can call store procedures from one database to another database.  We can also
insert store procedure results into a temp table ...

i have a table that has no index on a date column and a regular index
on
a customer_id column.  the customer_id will be somewhat volatile,  lots
of updates and

I have a custom third party shipping solution that interfaces with SQL
server. It connects with ODBC via a VPN to the SQL server. The
connection seams real slow to me, but maybe I am asking for to much?
The round trip from request of the client PC to the server and back

It's always great to run into problems on a Friday afternoon before a
holiday weekend, but here I am.
I'm not sure when this started happening, but if I try to get
properties on any of the databases on my SQL Server Express 2005 server

I have both SQL Server 2000 Developer Edition SP3 and SQL Server 2005
Developer Edition (9.00.2047.00) installed on my WinXP SP2 notebook.
I'm connecting from a Windows PocketPC 2003 Second Edition device which is
running a custom app which uses SQL Server CE 3.0.

I had just install MS SQL 2005 at my server computer ( OS windows 2000
server sp4). I have LAN in office with workgroup, and I have a problem
that I can't connect to MS SQL 2005 from client mechine. Previously, I
used MS SQL 2000 server.

Created a new alias with the SQL Server client network utility.  With
the connection parameters, changed the server name to the IP address -
still no success.
Edited the Sql Server Network utility to use port 1433 to use port 0

I am trying to insert data into varchar(max) via ODBC.
When I try to insert data. I am getting following error. Is SQLPutData
supported for varchar(max)?
1394-1e4c    ENTER SQLPutData

I hope somebody here can help me, as I have run out of ideas.
I am trying to export some data to SQL Server 2005 via ODBC. The data
consists, for testing purposes, of a single row and a single column. The
value itself is time, i.e. 08:20:54 (hh:mm:ss). I have created a test table

I have 2 development machines. SQL2000 is installed on the first one and
SQL2005 is on the second machine. Is it possible to register SQL2005 and
have an access to it on the first machine via Enterprise Manager? I'm trying
to do that and get messages that server doesn't exist or ...

I see how I can set the application name and workstation ID in the JDBC URL.  
I'd like to be able to supply information such as end user name and
workstation ID dynamically to the connection I get from the connection pool.  
I'm pretty sure you can do this in .Net.  Is there any ...

I am making a local connection to an instance of SQL Express on XP SP2.  I
get the following error message:
"Microsoft SQL Native Client: An error has occurred while establishing a
connection to the server. When connecting to SQL Server 2005, this failure

Please help I am getting the same error no matter how I change my
quotes.
Microsoft OLE DB Provider for SQL Server error '80040e14'
Incorrect syntax near the keyword 'Plan'.

I select the english download and accept the license agreement but
download.microsoft.com keeps downloading the file sqljdbc_1.0.809.102_fra.exe.
and not the new version in ENGLISH : 1.1.1501_101
Is there a work around ?