I have seen somewhere either in an article or a discussion thread on this site someone talking about "asynchronous sql execution"... Essentially they created a scheduled job using TSQL from...

I think you've done what you need for ports as far as I can remember...  The tricky thing will be your choice of Windows/SQL authentication - you may well find...

You can have up to 16 copies of SQL Server, MSDE, Standard or Enterprise installed on a single machine, each with different instance names.

We have a doc management application that has ~700k files in the single folder accessed via FTP on NTFS... works a treat

One backup...

When you say you can't login with the ID, I assume that the ID you set up in SQL Server is the one that you are logged in to Windows...

Your first query

SELECT * FROM mainMenuTable ORDER BY mainMenuIndex ASC; (= Tablescan)

needs to scan the entire table to retrieve all data (hence Tablescan) - probably not a lot you can...

To bring things back on topic...

1. As Remi said, check to see if you have indices on all of your foreign keys that...

Look at the sp_who or sp_who2 (this one is undocumented but gives more information) stored procedures - they give a wealth of information about current activity in the database.

Also, you...

Few points...

1. Try commenting out your delete clause and see if your variable is still empty - if so, then it is not the delete (I doubt the delete is...

Was the database involved in replication?

Simple google search on your error message gives some good indications - if one of them works could you please post here in case anyone...

What is the restore command that you are running?  You should restore from the (typically) single file that is generated by the backup database/log commands.  Do you have an .MDF...

Good point - not all of us are in the US   (I'm in Australia - we use dd/mm/yyyy)

Is there a way to change...

If you are able to, take a log backup of it after 8:40 (depending on the type of crash I suppose).  Then you can do the restoration stopping at 8:39.  If...

The from clause is quite neat - can be used in deletes as well with joins, etc - we had a post about it last week from memory..  Always something...

Try running SQL Profiler when executing your code.  See what the ADO recordset is trying to tell SQL Server - I would assume that it is issuing an update statement...