sql timeout

Results 1 to 2 of 2

Thread: sql timeout

  1. #1
    Join Date
    Dec 1969

    Default sql timeout

    I have a 162,000 record db with about 20 fields per row running on a dual P400 server. <BR><BR>If I run a select * query in enterprise manager, everythings alright, but if I try to filter or manipulate the data in anyway (sort, where, etc), i get a timeout even though I have the timeout set to unlimited. This is all in enterprise manager, not even putting it into asp yet. Anyone have an idea?

  2. #2
    Join Date
    Dec 1969

    Default locks?

    I&#039;d check for locks. In Enterprise Manager look under Management, Current Activity.<BR><BR>Maybe a long shot, but it&#039;s an idea.

Posting Permissions

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