Post reply

I need some help.... I cannot execute any query from sql 2005.

  • July 27, 2007 at 1:41 pm

    #175669

    Hi all,

    I need some help.... I cannot execute any query from sql 2005, when I try to execute a query it stays executing and I never receive any result set.   I uninstalled and re installed again SQL 2005 in my computer and also I installed the Service Pack and I am still getting the same.   Could you please help me or advice on this situation?

    Thanks in advance,

    Mauricio.

  • July 27, 2007 at 1:42 pm

    #723036

    What's the query you are trying to run?

  • July 27, 2007 at 1:46 pm

    #723039

    In fact with any query, for example if I run Select 1 or Select getdate().......,I got the same thing.

  • July 27, 2007 at 1:48 pm

    #723040

    Are you sure that the service is started?

    Hwo do you know you are even connected to the server?

  • July 27, 2007 at 1:52 pm

    #723042

    For example if I try to get the resultset or return all rows from the graphical interface (rigth click----> Open Table...) I do not have problems I receive the resultset but, If I tried to write a Select statement I have the problem so, I do not have problems with the connection I am connected to the server. I do not why it does not work when I try to execute a Select.....

  • July 27, 2007 at 1:54 pm

    #723043

    Never seen or heard of that problem.  I don't see how I cna help you at the moment.

  • July 27, 2007 at 2:14 pm

    #723060

    What version of SS 2k5?  What are your system's attributes?  Do you have the minimum requirements to run?

  • July 27, 2007 at 2:19 pm

    #723063

    I have the Standard Edition.  I was running select statements before and all was working fine but now for some reason it does not working.....

  • July 30, 2007 at 8:41 am

    #723320

    I have seen a similar behavior in Query Analyzer as well as SSMS.  If the Set Parse Only is turned on actual execution of the statement(s) never occur.  Also if the ansi_defaults have set implicit_transactions turned on, most sql statements return nothing, (all you get back is query execution complete, no recordset or record count).

    You can check SSMS here: 

    1. Tools
    2. Options
    3. Query Execution  (Expand tree)

      • Advanced  [Uncheck Set ParseOnly ]
      • ANSI  [Uncheck Set Implicit_Transactions]

     

     

     

    [font="Arial"]Clifton G. Collins III[/font]

Viewing 9 posts - 1 through 8 (of 8 total)

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