locked
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?

    HTH...

    Joe

    Tuesday, May 8, 2007 11:21 AM