Manage Learn to apply best practices and optimize your operations.

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?

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

Dig Deeper on Microsoft SQL Server Installation

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.