I'm sure I'm doing something pathetically stupid.
BUt I'd like to know what!
I have a remote hosted machine which has been running MSDE for quite a
while.

I have two computers who connected on the same workgroup. on each one of
them sql server database is installed
I would like to connect them together so i can transfare data between them.
What i need to do so they will recognize each other?

If I understand correctly, SQL Native Client must be used to access the new
features in SQL Server 2005.  What if I just want to access SQL Server 2005
but don't use any new feature, can I not install it onto client machine and
just use SQL Server driver comes with ODBC?

Is there a way to access 2 databases simultaneously using a single
connection string?
server: SQLSERVER
databases:

I was using sqlserver for asp .net applications and since yesterday I am not
able to start my sqlserver. The ERRORLOG under C:\Program Files\Microsoft
SQL Server\MSSQL\LOG is as below:
2005-11-30 16:37:28.89 server    Microsoft SQL Server  2000 - 8.00.760

How come I have to connect to my MSSQLSERVER instance using only "." or
"<hostname>", yet it does not work with ".\MSSQLSERVER"?  Yet all other
instances require the host\instance format? This seems a bit strange and
inconsistent.  Also, the common dialogs should be:

I've got a clustered SQL 2000 SP3 database that is killing the CPU on our
server.  The db is 66% fragmented, and I need to figure out what is taking up
all the CPU cycles. The application that uses the db has recently switched
to JDBC driver. I've tried running SQL profiler and I ...