Derrick is correct. unless you are getting "transaction log full" errors, in which case the NO_LOG option will work.

You are correct there is no default for DELETE, but I think the person was getting at what you said. The default options set for the FK.

Try changing the columns you get, I'd bet you get a different row cont. We fought this issue using Client Access going against a AS/400 and didn't get a resolution...

I would say no. You read by pages, and a page has to contain an entire row, so the order wouldn't matter.  I suppose that the query processor could short...

I agree with Antares. You don't want another Windows machine to be a router since that would be asecurity risk. Another SQL Server that could see both, while inefficient, would...

I assume the logfile is full for one of the databases. You haven't really posted much informaiton. You can try "backup transaction xyz with no_log" and then run a full...

replication is for data movement, not schema, permissions, etc.

I use backup/restore.

There's a few articles on this site regarding fillfactor and how it works. Basically if you're data is static, not many inserts/updates/deletes, choose a high fillfactor, like 80-90%. If you...

That works for insert, update,delete, but not for select queries. Fro that you'd need to run Profiler and then examine the data. I'd recommend you do this for a few...

Get a local administrator to connect using NT authentication and reset the sa password.

The references above are great. I wouldn't move master, just move the databases and use sp_help_revlogin to get the logins. You might need to use sp_change_users_login to synch them up...

you should be able to connect with the ip of your home computer if its running sockets. Be aware that this is a secuirty issue and you should have a...

Why not reinstall? It's easy, detach the dbs, script out the logins (sp_help_revlogin) and uninstall. The install std, run the script, attach the dbs.

Again the question, why? v2k will run in v65 or v7 compatability mode. The W2K3 kernel is substantially different, so there may be issues. W2K was a big change from...

This is most likely unsupported and I'm reaching back to remember how well it worked, but...

v65 was more "friendly" in terms of hacking the system tables. So we did a...