What is performance difference between joining tables
1. from the same database
2. from different databases located on the same instance of MS SQL Server
3. from different databases located on different instances of MS SQL

I don't know why i can not connect to a remote Sql server in my Enterprise
Manager, While i can do it through Query Analyzer.
Thanks

If SQL SERVER is configured as a Maximun concurrent user connections  = 1 (I
know 0 = unlimited) in Connection tab of server property ? Who will able to
login to server ?
Because i have a similar case and not able to login with any other sql

Im gette this error when I trie to export data or import data. I have tried
to reinstall SSMS
This means that it does not work ???
TITLE: SQL Server Import and Export Wizard

I am implementing my first webservices with Visual Studio 2005 with
connections to SQL Server 2005.
Here is the problem I am experiencing.
When I try to execute code for the webservice (local or remote) I get

The database that I just started to work with has a simple recovery model.  
The actual production database is 5 gigs while the transaction log table is
98 gigs. I can not figure out how the transaction log became so large. There
has never been a backup taken of the transaction ...

I'm reading columns from a table, including an image column.  The
image column is not bound because I don't yet know the size of
the BLOB.  The problem is that I can't get the ODBC driver to
stop reading the unbound column on SQLFetch().  It appears to

I Receive this message when I try to connect sql server 2005 express...
Cannot connect to LOCAL\SQLEXPRESS.
===================================
A connection was successfully established with the server, but then an error

Hi
I,m new to Server 2003 and I'm moving an ASP website to it.
This is what I have; an basic ASP web site that connects to a "SQL server
2000" database on Windows XP box, using IIS.

when user leave's the application for  while connection to server stops
and data shown in form is #deleted
how to prevent it?
sam

I am trying to connect to the SQL Server Integration Services on my
back end 2005 database server through SQL Management Studio. When I try
to connect I am receiving the following errors:
TITLE: Connect to Server

How to install Sql server 2000 by use sql authentication?
In stand-alone computer.
Please show step install program.
Thank you.

I've installed sql2005 on win2k3, running on virtual pc... I can connect to
the sql server using sql server management studio... Because I'm building
base environment for testing, I seal the machine using sysprep. When I start
a new machine, I get this error...

I have enabled remote TCP connections on my server *AND* i am able to connect
remotely through the management studio on my laptop. however, when i try to
connect programmatically, i get an "invalid connection" error.
Connection String:

Can you create linked SQL servers across domains ? If so do you need to do
something different from a normal linked server ?
Thanks
Si