That helped dramatically.

Thanks~

So a Backup Device is much like a DSN to direct traffic to a specific database?

The "what role does a Backup Device play" was designed to say, is it better...

I do not have SQL Server installed at the remote location so I will follow your second suggestion, which is the one that I was guessing was the way to...

Ok this has been incredibly helpful and educational.  I apologize for anyone who was trying to help me with insufficient information.  The last query submitted worked very well and, yes,...

There is obviously much I don't know about this process.  What is DDL?  Also, I will qualify my joins as you suggested.

Thanks~

Ok I am now connecting from machine to machine but it is REALLY SLOW-to the point where the system times out prior to connecting.  I am connecting to the machines...

Password hidden. I have verified that the password is the same on all machines in the workgroup.  I am now getting a message that says "Login failed for computer_name\Guest"

Thanks but there is no chance to use a domain controller at the remote site.  I thought that if I used "sa" and the associated password that I would be...

How do I open port 1433?

Thank you.  I tried to do that but the install generated an error.  There are 4 exe's that comprise SP4.  Analysis Services, MSDE, etc.  Do I need them all?  Is...

I am not sure-where do I schedule that?

I haven't had a chance to check the solution that involved splitting the updates by table.  Once I try that, if that doesn't work, I will try to rename the...

The sql statement is correct-at least it returns the correct statement in response.write (although you are missing a line break after sFinalSort)

Yes that is what I am doing.  I did not know that was not allowed.  Thanks for your help!