And preferably not rely on it being set one way or the other.

Quoted identifier being ON means that you can type "My Tricky Col Name" rather than using the standard...

Not quite right.  That assumes that OrderLineID is a candidate key on its own for the table, which it's not.

Nick wants something like

Order    OrderLineID

1          1

1          2

1          3

2          1

2          2

So the...

You cannot think in terms of Visual Foxpro using local foxpro database files with local cursors.  When apps are working with SQL Server they select the data then either perform...

Great article

Wow - congrats for finding that bug.  Wouldn't have thought to look there for a while   More out of curiousity than anything, what...

I had trouble with transactions and linked servers once before - I had SQL Server querying Oracle twice.  If done in a single transaction, the 2nd query would freeze.  If...

Are there any lulls in your data processing workload or is it a constant stream of logs messages that never slows down?

I would've thought that MSMQ would be ideal.  However,...

I had an assignment at university some years ago where we had to write a transport journey planner that allowed bus, ferry, train and walking trips between fixed (eg train...

Try looking for index/table corruption.  When you use a where clause SQL Server might be using an index which lets the results come  back to you but a full table...

For more info on SQL Server and implicit transactions look up

set implicit_transactions ON/OFF in SQL Server Books Online (the "help file" for SQL Server)

I don't quite follow - you obviously have more code in your job which would be an insert into your newly created table.  Just modify the script to not drop...

No probs - glad to help

When you say "This box does not appear when accessing the same databases from other systems on our domain" - do you mean that

a) The same databases are still hosted...

Few ideas...

Are your linked server settings the same on each machine?

MDAC versions the same?

Perhaps try applying SP4 of SQL 2000.

According to the MS article you provided you may need to...

I hate to ask, but are you doing what the error message states you should do to fix the problem?  Specifically, when you prepare an XML document, you get a...