SQL Server Performance Forum – Threads Archive

Enterprise Manager Error Pls Help

All,
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.
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=3112
Install sp6a for NT, reboot and install SP4 for SQL.
Luis Martin
Moderator
SQL-Server-Performance.com

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
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>