...so my implicit question is this: does anyone know why SQL Server running on Server A would drop a connection when a process on Server B initiates an SQL connection to...

Interesting. Most of the time I start Profiler against that server, it starts OK, but occaisionally I receive:

SQL Profiler

Failed to read the trace data.

Unspecified error occurred on SQL Server. Connection...

Lumigent Log Explorer for SQL Server can apparently recover dropped tables.

http://www.lumigent.com/Products/le_sql/le_sql.htm

"Use Log Explorer to:

• Identify the source of any data, schema, or permissions change

I'm afraid I don't have any answers to this question; I am experincing the same error myself.  I wonder if this problem is related to the other problem I am...

I ran into this problem just a few days ago, and found the answer. You need to specify quotes in the 5th column of the BCP format file. Here is...