[microsoft][odbc sql server driver]timeout expired

  • Hi,

    One of my users created a query in EM and received this message when he ran it.  He came to a fellow dba who received the same results going through EM.  I ran the query through QA without incident.  I just can't seem to find any documentation that pertains to these circumstances.  Can anyone tell me why this might have happened?  This is a SQL 2000 server sp3 and no query timeouts defined, all are at the default settings.

    TIA,

    lmp

  • 1)you can change the timeout settings of enterprise manager in the Tools menu -> Options.

    2)Is there a linked server in the query (default time out 600 seconds)

    3)Enterprise Manager is quite at managing, running queries is another story.

     

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply