Post reply

Query Analyzer

  • June 28, 2003 at 10:06 am

    #175973

    I'm having a problem with Query Analyzer.

    If I execute even the simplest of queries (ie SELECT * FROM customers) and hold down F5 to keep executing the query over and over, in less than 5 seconds the query locks up and never comes back (you can't even cancel the query).

    Does anybody have any ideas? Is there a licensing problem here?

    I'm running Windows 2003 Server with SQLSERVER 2000 SP3.

    Any suggestions would be greatly appreciated.

    Thanks.

  • June 29, 2003 at 2:56 pm

    #463585

    How many records/columns in customers

  • June 29, 2003 at 5:18 pm

    #463590

    quote:

    How many records/columns in customers

    10 records with just a couple of columns - it doesn't get any simpler than this.

  • June 29, 2003 at 6:24 pm

    #463593

    Not sure why you want to keep on pressing F5, but the following code will also goes into an endless loop. Hopefully it will not hang Query Analyzer.

    While 1>0

    Begin

    Select Top 5 GetDate(),* from customer

    WaitFor Delay '0:0:1'

    End

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

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