View times out in EM but not in QA

  • There's view that I can run in the Query Analyzer but when I run it in Enterprise Manager, I keep getting the "ODBC Driver Times Out" error message.

    It takes a while to run in QA, over 40 seconds.

    I've increased the long query time in the DSN configuration but it still times out in EM.

    I can't touch the view (not until I've tried everything else) yet because it was written by someone else...

    Anyone know why I would be able to run it in QA but not in EM?

  • It is to do with the way in which EM makes its connections. You should try the new Management Studio if you have a timeout fetish. On big tables a simple column modification will fail with a lovely big .net error! GRRRRRR!

  • I have always had better luck with Query Anaylzer than Enterprise Manager - especially when altering tables...

    I wasn't born stupid - I had to study.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply