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
AdilDid 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...|||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...

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
HaseebIf the drive that holds the temp directory is running low on space this
error can be generated. Enterprise manager creates temporary files when it
returns all rows.
Rand
This posting is provided "as is" with no warranties and confers no rights.