On some level I know how to use a trusted connection, but I am not actually
certain what a trusted connection really is. I can't seem to find a clear
explanation of what it is. What I mean is, was long as windows authentication
is configured with sql server 2005, is any valid ...

We have a lot of W95 clients that can't be upgraded. I want to use SQL CLR so
I need to use SQL 2005. Is there an ODBC driver for W95? I've tried MDAC 2.8
but without success (installation fails on W95).

here is the string:
Data Source=.\MSSQLSERVER;AttachDbFilename="C:\Program Files\Microsoft
SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdf";Integrated
Security=True;Connect Timeout=30;User Instance=True

I have a remote server with SQL Server 2005 Express installed on it. I
try to connect to it from my local machine using TCP/IP. I have the
remote SQL Express set to mixed mode and enabled TCP/IP.
If I connect using a self-created login it works fine and I can run

We have 3 SQL servers.
Server01 Win 2003 w/SQL 2000 192.168.1.1
Server02 Win 2003 w/SQL 2000 192.168.1.2
Server03 Win 2003 w/SQL 2005 192.168.1.3

I have Microsoft Access ADP 2003 connected to a database running on
SQL Server 2000.  I just created a trigger on Table A to run on
UPDATE.  I also have a stored procedure that periodically updates
Table A.  The problem is that the stored procedure fials and returns

I have a database in warm standby
The database was detached with sp_detach_db
There seems to be no way to sp_attach_db
and keep the database in standby mode?

I am remoting into a sql server 2005 express via vpn, and while my user acct
does not have admin rights, it is a member of all of the sqlexpress groups.
Needless to say I didn't install this sql server, but I think it was laid down
with all of the defaults intact. Vague, sorry.

I need to connec from SSIS to RDB. As far as I know, there is no ODBC in
SSIS, So how can i connect to my RDB??? I thougt may be to use some how the
JDBC. Is it possible???

I am using the MSSQL 2000 sp3 JDBC driver (version 2.2.0029), and I found a
problem while using getTimestamp(, calendar) and setTimestamp(,,calendar).
I am trying to set my time stamps in GMT into the database. All works well,
except for one hour during the year, corresponding ...

I wish to create a new access database each week whos name includes the
curent date, then to create 7 tables in the database eg '27 Jul 2006.mdb' one
for each day
I then wish to insert rows into these tables,

I need to develope a c++ application that connects to a MS SQL 2000 server,
soon to be 2005, via OBDC.  I want to develope the app on my workstation
which rarely connects to the server.  Can I use MSDE as a development engine
and all the ODBC will be the same for the SQL server?

I am trying to write a TSQL Script for maintenance that willl read the
databases from sysdatabases and change to each database inturn to perform
some maintenance tasks.
Problem is I can't get SQL to change to the next database.

Two instances of SQL Server 2005 cannot "see" each other. One is Developer
edition and one is Standard edition. Standard editon is running under
Virtual PC. I would appreciate any suggestions on how make these two
instances visible to each other.

I want to understand the IP Addresses tab of the TCP/IP Properties in SQL
Server Configuration Manager.  The following settings are from the default
named instance of SQL Server 2005 Express (computername\SQLEXPRESS) on a
Windows XP SP2 machine with IP Address 192.168.1.151.