Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Location
    bangalore
    Posts
    270

    Unanswered: Fetching Record From Table

    Hi,
    I am facing a peculier problem. I have 3 records in my table. when i am trying to fetch the top 2 its able to fetch the records. but when trying fro moire than 2 (say top 3 or just the *) it say time out. can any one help me out in this regard.


    Below is the error that I get when tryong to open the record from SSMS

    SQL Execution Error.

    Executed SQL statement: SELECT Transaction_ID, tril_gid, WorkGroup_ID, CreatedBy, CreatedDate, ModifiedBy, ModifiedDate, LCID FROM Symp_TransactionHeader
    Error Source: .Net SqlClient Data Provider
    Error Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
    ---------------------------
    OK Help
    ---------------------------

    Thanks,
    Rahul Jha
    Last edited by DBA_Rahul; 09-17-07 at 07:30.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    where's the TOP in that query?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    May 2004
    Location
    bangalore
    Posts
    270
    there is no top in the query........... the system wil generate the query when you try to open the table from ssms..............

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •