Congratulations!

Are both machines in a domain?

Terminal services will run in a browser. It will be slow, but it could work.

Can you not just recover the file from another server?

I think if they both have the same name/password it should work. You might need the same local account on each server.

I'd do a backup for sure and then get a checkdb running. If there are any errors, call PSS.

I didn't write the question, but I was under the impression that the website might use it's login, which would be a single login.

I think it also depends upon the...

If the text in syscomments isn't readable, then it's encrypted.

IT seems most people that aren't experienced DBAs like the detach, attach method. I'd recomment that. (search detach on this site). For the logins, sp_help_revlogin from Microsoft (search technet) can...

Not sure about Crystal or Access, but here's some basic ASP tutorials. http://www.realworldasp.net/

You really have a two part process. One to get the lookups and display for the user to...

This questions, as well as most on Reporting Services, were provided by a reporting services consultant (whom I greatly thank for his efforts). In the context of reporting services, which...

use with_tableresults and put the results in a table for later viewing.

Pls don't cross post. Answered in another thread.

I don't believe you can do some of these without being able to read the data. You could grant some roles, like backup or security to someone without having them...

Not sure about heap tables, but if you have a clustered index you can check which datafile these are stored on, which is the same as your table.