I have two instances of SQL Server 2005 Standard Edition running on two separate dedicated servers (let's call them DB1 and DB2). At the moment DB1 is very busy and DB2 is mostly idle. Is it possible to configure the instance running on DB1 to utilize the processor on DB2?
For example, I connect to DB1 and execute "sp-heavy-going" and I would like DB1 to process this request using DB2's processor. Whats the best way to go about achieving this?