SQL Server Performance Forum – Threads Archive
Enterprise Manager Error Pls HelpAll,
Sqlserver 7. From the Enterprise Manager when i right click on any table
Return all row. I am getting the below error An unexpected error happened during this operation.
[Query]- Query Designer encountered a Query 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.
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.