is there any way to release locks from all recordsets/queries to linked
tables? I have Access front end with SQL Express 2005 database back end. I
keep having Query Time Out error while doing record updating because the
table is locked. I know we can use Exec sp_lock to find ...

I have two machines in a workgroup. Both XP Pro. On \\DELL8300 is SQLExpress
2005 the other \\DELL4600C has SQL 2005 w/SQL Management Studio.
When I try to Connect w/SQL Management Studio I can Browse in the Connection
window and see the DELL8300\SQLEXPRESS listed.  When I select ...

I want to connect ASP with SQL Server 2008 through following string but it is
not working plz help
set db=Server.CreateObject("Adodb.Connection")
strConnection="Provider=SQLOLEDB;Password=abc;Persist Security Info=True;User

Platform: VS 2008, SQL Server 2005, OleDB
Hi,
I am using OleDB connection in vc++ code to insert data in sql server
database. Single connection is being used by multiple threads to insert

We have a Linked Server defined on our Sql 2005 server.
It points to an MDB file located on a share on another server.
It works sometimes and doesn't at other times.
Restarting SQL sometimes fixes the issues but not always.

I have two separate databases on a SQL 2000 server with separate DSN's. I
would like to run two different queries on the databases and combine them
with a UNION and I am wondering if that is possible?
I also have a SQL 2008 developmet server available but production need to

I have system set up using SQLExpress with remote connections and ODBC that
was working fine until today. Now the named instance cannot be found from the
remote machines. The Browser is running and active, the Surface Area
Configuration shows that local and remote connections are ...

I am getting the following error when I try to connect to the remote machine
hosting SQL Server 2008 Express (outside our domain):
A network-related or instance-specific error occurred while establishing a
connection to SQL Server. The server was not found or was not accessible.

Apologies if this is in the wrong forum.
I have SQL Server 2000 installed on my laptop.
SQL Server 2005 is also installed as a named instance, which I don't think
is relevant to my problem.

My application encountered an issue as mentioned below after migrating the
sql server to 2005.
10054:A transport-level error has occurred when sending the request to the
server. (provider: TCP Provider, error: 0 - An existing connection was

I am using MSSQL Server 2005(not express) and MSSQL Server Management Studio
2005(also not express).  The Management Studio can connect locally, however
when connecting remotely I get the following error:
Cannot Connect to XXX.XXX.XXX.XXX\MSSQLSERVER

Hey All,
I've got a company laptop w/query analyzer, visual studio, etc.,
installed on it.  When my laptop is physically connected to the
corporate network, I can use QA to connect to both departmental server

Is it possible to use the Windows host file to map an alias to a named Sql
Server instance ?
So , the hosts file would read something like :
<sql server ip address>\<instance name>    <alias>

Any assistance on the below issue would be helpful..
I have 2 databases (both SQL 2005) and are trying to create a database link
between them so we can access objects contained in the Remote Database
'ARSystem'. The Hostname of the Database is 'basARSystem'.

I need to develop a geo search module. I understood that SQLSERVER 2008 has
this function as a stored procedure. Does anybody know of a good tutorial or
documentation in this subject?
Thanks,