The user interface for SQL 2005 Management Studio is strange when you're
messing with a linked 2000 server default instance.  Maybe this isn't
supported.  :-)
In the Object Explorer, go to the Linked Servers item, right-click and

Configuration:
Sql server running on a test machine with mirrored drive for OS and SAN for
data.
Problem:

After months of frustration, not knowing what was causing the disruptions, I
caught the culprit live, in its tracks.  And that beast is Active Sync.  I
was running a long process, generating test data, and when I pulled my PDA
out of the cradle, I heard the normal "ding", signifying ...

I've been using Delphi for years (Win 32) and connecting to my SQL Server
databases with no problem.
I am now trying to learn both VB and C#. (Visual studio 2005)
From the Data menu, I select Add New Data Source

We have an application that we run at our business that takes a long
time to run on our old server.  We purchased a new server and I have
been told we are going to run SQL Server 2005 STD x64.  When I ran the
program as a test on our new server it took twice as long as the older

I am unable to login to Server Management Express using Server
Authentication.  I am able to login using Windows Authentication
though.  I setup a new logic using Server Authentication but get the
following message:

I am looking for guidance.  I do SQL and other development on 2
computers, and I work remotely from my company's home office.  (We use
SQL 2000 and 2005 both.)
My "main" computer has a VPN to the home office.  Outside of that, and

I have just installed Sql server 2005 on my Win XP Pro machine.
When I go into the sql server management studio, there is only
one entry under the "database engine" entry in the  registered servers'
panel on the left. It is MyServerName\SQLEXPRESS.

I have just reloaded my PC with Vista Ultimate. I have installed SQL 2005 and
I can not connect to the local DB. I can connect to remote DBs no problems. I
have installed sp2 and had no issues. The error message I am getting is.
TITLE: Connect to Server

I have a named instance of SQL Server 2000 called VTMS on a server called
VTMS which resides on a cluster.
I am trying to connect to a database on VTMS from a webapp (URL
http://reports) hosted on a server called RPT (ASP.Net 2.0) using Windows

We are using Hibernate 2.0 with MS 2005 JDBC Driver 1.1
For character based parameter fields, JDBC seesm to force one of two types:
nvarchar(4000) or varchar(8000). This difference is if we set the connection
property SendStringParametersasUnicode.

If you edit File and Print Sharing in Windows Firewall, you'll see that it
lists 2 UDP ports and 2 TCP ports.
This is something that cannot be done normally but is offered through the
XPSP2 resource DLL. You can see this by looking at the registry entry for

I am new to SQL Server, and using the Express edition. I can't seem to find
the way to create relationships between tables. Any reference info will be
appreciated.

Dear Sir,
Actually i want to ask, how to install the SQL Server Desktop Edition
2000 Client Tools only from the Command Prompt ? i have gone through the
internet but all the responds were about SQL Server Desktop Edition

I am trying to get info from a linked server, but the instance is not the
default instance.  I have tried:
select *from myserver\myinstance.mydb.dbo.mytable
but get a syntax error due to the backslash.