View times out in EM but not in QA

• derek-346838

  Newbie

  Points: 1

  More actions

  July 7, 2006 at 3:12 pm

  #169097

  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?

• David.Poole

  SSC Guru

  Points: 76145

  More actions

  July 7, 2006 at 3:37 pm

  #648087

  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!

  LinkedIn Profile

• Farrell Keough

  SSCoach

  Points: 17414

  More actions

  July 7, 2006 at 3:38 pm

  #648088

  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.