I have two servers, one running a legacy ERP database on SQL2005 Standard
Edition, and the other server is running an SAP database on SQL2005
Enterprise Edition 64 bit.
Both servers are set to use Windows authentication, not Mixed (SQL and

SQL2K/SQL2K5
Have run into a situation where a record lock has caused a problem for users
. .  .not exactly unheard of.  The lock encountered was on a single record.
The lock persisted for about 14 hours. The SPID causing the lock was not

ISSUE:  Cannot connect to newly installed SQL 2008 server via ODBC from
clients (web servers) in the DMZ.
SQL Server Specs:
SQL Server 2008 Standard

Help,
I am writing a data import application that will import data in to
sql
server database.

I've inherited some code that uses this connection string:
"Driver={SQL Server};Server=sqlsrvr\sql2005;Database=test;UID=user;Pwd=xxxxxx"
However, the SS2005 instance is running on 2789.
How is this working?

I've developed an app for our company using VB.NET (winforms) and SQL server
express running on our SBS server 2003 Standard
The app works really well within our LAN but I often work remotely and quite
often would benefit from using my custom app.  I've tried the VPN but for

Setup...
Physical Windows Server 2008 running DNS and Hyper-V (RTM)
VM1: Running IIS 7
VM2: Running SQL Server 2008 Enterprise

I am adding support for Unicode data to our application.   The customer has
the option of using our built-in Apache DBCP connection pool, in which case
we control the URL for the database connection.   They can also configure
their app server with a DataSource connection pool and ...

I am trying to develop a T-SQL script to copy data from our internal to the
SQL server database at our webhost.  This is probably pretty straightforward
and a fairly routine task in the database world, yet I fail to see it in the
documentation.  My hunting on the web has led me ...

I am using Java 1.6.0 to call a stored procedure on SQLServer 2005.  The
stored procedure iterates a server side cursor, and then inserts into a
table its status.  However, I am getting a SQLException :
2008-12-15 16:26:26,624 ERROR [main] sqlRunner.SqlRunner (SqlRunner.java:66)

in our development project not all of use have a linked server entry at our local SQL Server installations.
At compile time we're running a couple of SQL scripts to update our local databases.
Unfortunately the Stored Procedures containing statements addressing a linked server ...

I am attempting to import a CSV file using the Bulk Insert sql command...
USE datasheets
BULK INSERT tblgrades
FROM '\\PHS-CI-TEST\c$\book1tab.txt'

We have systems of 1000's of units that occasionally save small amounts of
data to an SQL server (2000 currently), but we don't want  and don't see the
need to buy 50 or 100 client licences for SQL when IIS provides basically
unlimited users to SQL server.

Using SQL 2000 If I move from one servername to a new servername is their a
way to point the old servername to the new servername without changing all
the ODBC Connections, Ive tried DNS Entries and that does not work.

I am a java programmer.
I am developping to using SQL CE. But there is a problem.
I should don't use well. Don't be supported yet ?
If JDBC Driver isn't supported, when it is scheduled?