none
visual studio 2005 hanging application DevEnv.exe RRS feed

  • Question

  • I have a sql query in the VB Query Editor for a report (SsRS 2005) and the sql query is about 700 lines long...

    the sql works in sql management studio but fails in VS 2005 with this error: I get this error hanging application devenv.exe, version 8.0.50727.42 when

    This is when I try to create a report with this query.
    Wednesday, May 27, 2009 1:03 PM

All replies

  • How long in seconds does the query take? If it's very long you may need to increase script timeouts for IIS since it's rs2005 and uses a website, this may bubble back as an error in the ide, not sure on that but it's worth checking.

    Also, the number of lines isn't as important as the details of the query and how optimized it is ... sorting out the subqueries to not slow down the main flow is a typical problem.
    Wednesday, June 3, 2009 3:58 PM