Reply back from Microsoft

Hello John,

This is Rob with Microsoft SQL Server Support. This is a follow up to the voice mail that my manager and I left for...

Matt I'm hearing similiar from other sources and appreciate your response. I have quite bit of developement work if we need to adjust to this new behaviour, obviously not please with Microsoft...

Same sql build and server config. The databases are identical, the row counts are the same.

Think it's the O/S in particular index server

Try this in Northwind and then look at the execuion plan.

Select * from "Order details" od

inner join Orders o

  on od.orderid  = o.orderid

 and  o.orderdate > '5-01-98'

 go

Select * from "order...

That's it thanks!!

Arghhhhh

I have had this problem before (17883) It is a thread/scheduler issue, probably because the sql scheduler (internal) is timing out with the link server operation....

Still don't see log shipping being a solution. Why not use a DTS, or a script to export and import the data. Create a link server, or backup and restore...

Joe,

Last I checked you couldn't use log shipping as a way to deploy schema changes.  'Once our applications are all testing againt this test database environment, I will...

Oh great nobody has seen this before?

Try doing a link server to the oracle server, see if you can get there from there.  Could be a RPC issue

What happened to Randy, is he still there?

Overworked, underpaid, and those stock options aren't what they used to be.  Great for college grads, you'll work with some of the greatest people out there.

SQL Server dev team is not a place...

Is there a sarbanes-oxley for idiots book?

What is the sarbanes-oxley act and as a DBA why should I care?

Always an admirer of your work Steve, but you have way too much time on your hands. If you have some free time I have some servers that can use your expertise.

Dying at...

Thanks Greg,

John Zacharkan