Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Location
    Mars
    Posts
    115

    Unanswered: Enterprise Manager Error Pls Help

    Hi All,
    Sqlserver 7.

    From the Enterprise Manager when i right click on a table and select
    Return all row. I am getting the below error

    An unexpected error happened during this operation.
    [Query]- Query Designer encountered a Query error: Unspecified error


    When i use Query Analyser i am able to retrive the Data
    Pls help Its Urgent

    TIA
    Adil

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Did you start and stop EM


    Why is this urgent btw?

    EM is quirky...if you deleted an object it might still be referencing it...

    Don't use EM to query data in the first place....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Nov 2003
    Location
    Mars
    Posts
    115
    Hi,

    I didnt stop and start EM
    Most of the programmer are using the EM and complaining. And non of the objects are deleted. It is happening with all the Tables
    Pls help me out

    Originally posted by Brett Kaiser
    Did you start and stop EM


    Why is this urgent btw?

    EM is quirky...if you deleted an object it might still be referencing it...

    Don't use EM to query data in the first place....

Posting Permissions

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