locked
Tsql RRS feed

  • Question

  • while running the view in sql server 2005 i m getting this error:

    error source: .Net SQL Client Data Provider

    Error MSG: Timeout Expired.The timeout period elapsed prior to completion of the operation or the server is not responding.

    Monday, May 30, 2011 11:16 AM

Answers

All replies

  • How  do you run the view? SSMS or SELECT * FROM view?

    How many data does it return?


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Monday, May 30, 2011 11:23 AM
  • through select command but not working

    plz help

     

    Monday, May 30, 2011 11:34 AM
  • Hmm if every command (select *from tbl, EXEC stored procedure) whatever does not work) looks like client tools got corrupted, is it possible re-install client tools
    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Monday, May 30, 2011 11:40 AM
  • Hello,

     

    Have you checked SQL DB service is running fine?

    Also try to run query using Select top 1 * From YourViewName

     

    Thanks,


    Raheel Khan
    Monday, May 30, 2011 11:51 AM
  • Can you post the view definition? Most likely this view is not optimized for good performance and therefore client application is timed out. You need to fine tune this view.
    For every expert, there is an equal and opposite expert. - Becker's Law


    My blog
    Thursday, June 2, 2011 3:05 PM
    Answerer
  • Any progress?
    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Sunday, June 5, 2011 7:04 AM
  • First try to execute the query which you have written in you view, see if it works, if it works then try to execute select * from YourViewName in SSMS query window, if this also works that mean there is no problem with you view, you need to repair you sql client tool.
    Mark this post as answer if this resolves your issue.
    Everything about SQL Server | Experience inside SQL Server -Mohammad Nizamuddin
    Thursday, June 9, 2011 5:15 AM
  • Hello Napster,

     

    Any update on this??

     

    Thanks,


    Raheel Khan
    Saturday, July 9, 2011 3:22 PM