using sql management studio View is timing out. RRS feed

  • Question

  • I have setup the management studio so that basic queries do not timeout for 5 minutes.


    This query I run takes about 1.2 minutes to run. I created a view vwGetData and the view timesout at 15 seconds every time.


    But the basic select does not timeout.

    Why is that?

    Monday, May 7, 2007 3:58 PM

All replies

  • Have you checked they query plan to see if the view and the select statement are being optimized differently?



    Tuesday, May 8, 2007 11:21 AM