Ask the Expert

Error with SQL 7 Enterprise Manager

I received the following error after trying to open a table in SQL 7 Enterprise Manager:
Query Designer encountered a query error: Unspecified error

I eventually had to reboot to clear it. What causes this, and is a reboot necessary?

    Requires Free Membership to View

It's called software. If you are running on a Windows platform and using GUI tools, sooner or later, they will GPF. Yes, I know GPFs were eliminated with Windows 95. They're called page faults now. Yes, more than likely you will have to reboot. When you apply a service pack to your SQL Server, make sure you also apply that service pack to the client tools on your workstation. There were several fixes bundled in the service packs that were related to client tools. Also, Enterprise Manager makes HEAVY use of IE components. If you are like most people and are constantly upgrading your browser, you can blow up EM that way also.


For More Information

This was first published in June 2001

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: