Query Designer error

Checked out BOL on this issue, but not enough info received to troubleshoot. Hoping someone out there has some input.

This issue is only happening on the server side not the client. Also, it suddenly appeared on three different machines.

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

The how: In a database, go to tables and select a table known to have data right click on mouse and select Open Table, return all rows. This is when the error appears.

BOL states the the file may be corrupt or from a non-supported version of SQL Server EM. Nothing was installed on these servers and we're still on SP2. This error just all of a sudden appeared and spread to 3 different machines...

Another issue is the Return to Top function is disabled. This function provides the maximum number of rows to fetch.

Any assistance would be appreciated! Thanks.

Hi, I tried this before, it did not work.

------------
zahid at 2/10/01 4:48:44 PM

Hi,

Did U try restarting your server, and then do the same.

If its not working, then...
1) Run DBCC CheckDB, if DBCC is Successfull then it should work from QA also
ELSE

Take the backup of your master DB, and rebuild master Database, and then check it out.

Best of Luck,
Zahid


------------
Lisa at 2/9/01 6:38:09 PM

Checked out BOL on this issue, but not enough info received to troubleshoot. Hoping someone out there has some input.

This issue is only happening on the server side not the client. Also, it suddenly appeared on three different machines.

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

The how: In a database, go to tables and select a table known to have data right click on mouse and select Open Table, return all rows. This is when the error appears.

BOL states the the file may be corrupt or from a non-supported version of SQL Server EM. Nothing was installed on these servers and we're still on SP2. This error just all of a sudden appeared and spread to 3 different machines...

Another issue is the Return to Top function is disabled. This function provides the maximum number of rows to fetch.

Any assistance would be appreciated! Thanks.