Enterprise Manager Error Pls Help | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Enterprise Manager Error Pls Help

Sqlserver 7. From the Enterprise Manager when i right click on any 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 TIA
Same thing that other post.
Install sp6a for NT, reboot and install SP4 for SQL.
Luis Martin
See what account your connecting to the database using. Is this the same account you use in query analyser ?
Are you up to date with client tools service packs, I think there was one for sql 7.0 client tools.

Also, keep in mind that when opening tables in EM and returning all rows, you must allow for enough locks for sql to perform this. Avoid doing this if you dont have to. Heck, avoid opening tables this way at all if you have QA. Chris
I’ve had this issue as well on a cluster. A reboot was enough for me.
Latest SP will fix and follow this KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;Q273472 for further references. And make a practice of retrieving rows from QA rather than EM as this will hogup SQL resources if any other intensive query is running, don’t risk it when other alternatives are availble. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.