[dba-SQLServer] Which machine does the work?

Machine B is doing the work.  To truly understand everything that is
happening inside your SQL Server installation, you need to invest in
software that allows you to read the log files so you can follow the
transactions.

Doris Manning
mikedorism at verizon.net

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of JWColby
Sent: Thursday, August 31, 2006 7:54 AM
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer] Which machine does the work?

I have two machines, both running SQL Server instances.  MachineA has
registered the database on MachineA and the database on MachineB.  MachineB
has done likewise.   MachineA holds a database with a table to which I want
to add an index.  If I open EM on MachineB, select the database on MachineA,
open a table in design view and "add an index", where is the work performed?
Does MachineB actually do anything?  Or does MachineB simply send a command
to the SQL Server instance on MachineA telling it to add the index and all
of the work is performed on MachineA?
 
John W. Colby
Colby Consulting
www.ColbyConsulting.com