I've just had a go to connect to my SQL Server 2000 with latest patches,
through the Internet using an Access 2003 adp project.
While the connection is immediate, the queries are not!
Apart from modifying the application limiting the number of rows returned, I

we got a situation with sql 2005 server that configured to be access with
both name pipes and tcp/ip.
while accessing the server via name pipes is very fast other method ip is
very slow

I'm working with MS-Access and (2) SQL Server db's, both with case
sensitivity enabled .
In one case, I have a query that links a local table, with lower case codes,
to a SQL Server table with upper case codes - All matching records are

Not sure if this belongs here or in a Visual Web developer forum, but I think
the problem is SQL Server.
I installed SQL Server Express 2005.  I can access it from the SQL Server
Management Studio Express to add databases, add tables, etc.

Hey all,
I am in a domain A and want to make a database backup from domain B (dmz)
which I have sa password for. The backup is performed with a maintenance plan.
The backupped files is going to be saved on a file share on domain A.

We get this when we add IP addresses to the Windows system when SQL 2005
database activity is on-going:
"Database error: A transport-level error has occurred when receiving results
from the server. (provider: TCP Provider, error: 0 - The semaphore timeout

I have a good spec box running Windows Server 2008 with SQL2005 SP2.
I have a few machines running Vista SP1 that run Visual Studio 2008.
When I try and connect to a database via VS2008 Server explorer I initially
get time out errors. After setting the timeout (via Advance ...

I have been told by our consultant that we cannot access our SQL Server over
the WAN without corrupting our data, is this true?
Thanks for any help,
David

Hi, folks - I tried this question in the OLAP group without any responses,
so I'm casting my net a little wider in hopes one of you may be able to help
me:
I'm an Analysis Services noob, running the SQL Server 2005 Analysis Services

I'm developing an application that must support connecting to SQL
Server 2005 as well as SQL Server 2000. Which driver should I use for
the connection?
1. Use SQL Native Client driver for both 2005 and 2000.

My MS Access app links to an SQL Server 2000 db which includes a linked
server.
A pass through query  like "select * from linkedtable" works fine. But
"select * from linkedtable where linkedtablekey=1" fails - ODBC timeout

We recently purchased a new SQL 2005 server that I need to import a DB from
another server. in order to connect to the "other" server I have to use a
3rd party thoroughbred odbc driver. On our old SQL2000 box to perform this
task I would select import and next to data source I ...

First I would like to apologize if this is the incorrect forum to ask the
following question.
I have a linked server  in SQL Server 2005 to a SQL 2000 server with a name
with a \ in it ex. test\server.  When I try to do an openquery SQL errors on

I'm having a problem with a job on an SQL 2000 Server that is linked to pull
data from an SQL 2005 server.  When I enter my infromation into the Job Step
properties and parse the SQL, the system tells me it is fine.  When I run
the code through query analyzer, it also works fine ...

Hey guys! Good News. Secure Auditor is new software that identifies
vulnerabilities in Windows, Oracle, MSSQL and Cisco Routers. So
exploit vulnerabilities and enjoy additional 30 tools along with
scanning, auditing, forensics and penetration test. Crack passwords of