It seems that developers decided to make a few "shortcuts that will not affect anything previously done", and that project managers decided not to spend time on "something that was...

Take look at "hints" (more specifically "table hints") in BOL in the "Index" tab. "Hints" is there as a separate keyword.

Hints let you "instruct" SQL Server on how to to...

Try this one:

1) create a primary key - integer, identitiy

2) run bcp or Bulk Insert statement

This should help if BCP does not reorder the data before importing, which I doubt.

The thing might be that records with the same primary key are already inserted (before, or insert is executed more than once - error?) into this table. Is your table...

Set timeouts on components within the package.

As far as I know, there's no way to set timeout for the entire package.

"A set of ADO classes - version 2.20"

http://www.codeproject.com/database/caaadoclass1.asp

"ADO Connection Strings"

http://www.codeproject.com/database/connectionstrings.asp

"A set of ADOX Classes"

http://www.codeproject.com/database/caaadoxclass.asp

Try http://www.joelonsoftware.com/articles/fog0000000073.html

And don't be that hard like Joel, give it a bit loose

But, the point is, don't take someone who knows supetech...

Hm, maybe you wanted to select 2 colums from patients, then do the join using those two columns (or primary keys instead?) on rows cointaining "%x%" and return all those...

Have you tried to play with quoted identifier stuff (to use both " and [], instead of just [] and treating " as plain character)?

Or, the simply solution, try to...