I have a sqlserver 2005 database with Access 2003 front ends.
The data tables are quite small in terms of record numbers.
One table has 100 or so fields.
There was a problem with this table whereby when the user went to edit

On our website, typical page processing uses the ADO.NET command object to
request data from SQL Server. There are a variety of scenarios possible.
However for argument sake, let's say we are using SqlDataReader,
parameterized stored procedures, connection pooling, .NET 1.1, and ...

I have a SQL Sesrver 2005 database file (.mdf) and I'll be transporting it
to another machine for use inside SQL Server 2005 Express Edition.
Will I still be able to use Integrated Security (trusted connection) if I
simply drop the file onto a location of my choosing on the target ...

The driver download page says that new driver has been tested against all
major app servers including Weblogic. I can't find proper installation
instructions to install the new driver for weblogic 9.2. Can anyone share
what needs to be done?

Hi! I have a problem enabling access to my 'sa' login to a couple of
application db's it fails each time. I think the problem lies herein:I am on
Sql 2005 BTW....When I go to server properties/security it shows,
appropriately, Mixed mode authentication. However, when I click on ...

I am currently using LiteSpeed version 4.8.3.00025 to backup my sql servers.
Currently they are all setup to backup via unc to a central backup server but
over the past 3 to 5 months the backups have been failing.
In the application log we see this:

I am trying to connect to one of our SQL boxes.  When I'm in the office, on
the network, I have no problems either through Ent. Mgr. or Crystal Reports,
Visual Studio.NET, etc.
However, when I take my laptop home and connect to our network through VPN,

We have a dev and a production box. I can connect to the dev box fine
with my Ruby program either using and ODBC connection, or through
win32ole. I specify the host as of the form dev.office.mycompany.com
which is on our intranet.

I am having a hard time finding any information on an error I am receiving
from attempting to connect 2 SQL Server 2005 servers  linked server. I
am setting the linked server to use the credentials of a SQL Server login.
In searching the web, someone suggested enabling OLE ...

A reality check please...
After changing the domain administrator password, we are no longer
able to connect to databases on a MS SQL Server 2000 server when
attempting to use ODBC drivers from W2K workstations.

I have a program using ms sql. It worked fine for some time, but
now each time the program access the databases it outputs "Connection Failed
SQLState 28000, SQL Server Error 18456, Login failed for user 'sa'".
After pressing OK it gives an option to input a new password manually, ...

I'm running SQL Server 2005 Standard Edition.  My SQL Server has been
running on the same Windows Server 2003 box for 2-3 years without a problem
until last week.  When I launch management studio and try to connect to the
database engine I get the error below.

How to tell sql server the maximum size my temptable will grow so that it
does at most 1 memory allocation?

I have a work around for an application use Integrated Security
instead of SQL Security (which is great).  I need to use named pipes
for this to work.
I only got it to work after I did a SQL 2005 Connectivity and Client

In some computers, just a few in thousands, appears the following message
when try to login in SQL.
Connection failed:
SQLState: ‘S1T00’