Q

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

This was last published in June 2001

Dig Deeper on Microsoft SQL Server Installation

PRO+

Content

Find more PRO+ content and other member only offers, here.

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.

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

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close