Enterprise Manager Query functionality

From: 11Oppidan (11Oppidan_at_community.nospam)
Date: 02/14/05 

Date: Mon, 14 Feb 2005 10:33:01 -0000

Hi,

If you right click on a table in a database in Enterprise Manager you have
an option to query the database. If you select this you get a Access like
UI which helps you build SQL queries.

This stopped working on my machine for some unknown reason, and started
throwing an error. Re installing SQL did not resolve this issue. Only when
the machine was re imaged did it resolve the problem.

Error Messsage was:

Title: "SQL Sever Enterprise Manager"
Msg: "Provider Cannot be found. It may not be properly installed"

We also have this problem with another machine so would like to known what
might be causing us to loose this functionality and why a reinstall doesn't
work? We do have some third party addins installed on these machines like
palsiade @risk and crystal ball - is it possible for third party addins to
affect SQL like this?

Relevant Pages

  • Maybe the Records Are There After All
    ... The indication that the records were DELETED is that Server Enterprise ... Type in Server Enterprise Manager and then was making notes and documenting ... the larger database from last night STILL SAYS that it has ZERO records ... Is there some way to monitor the things that SQL is doing in the BACKGROUND ...
    (microsoft.public.sqlserver.server)
  • Re: RESTORING CRASHED SITE WEBS
    ... they are already there) before installing WSS and then to add them back ... >>> I have everything kind of restored but can't access the SQL ... I can't login using any existing accounts. ... I put in the database server name and ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: software needed to input data
    ... ENTERPRISE MANAGER give you a simple one table at a time ... Your programmer might have proprietary rights to the ... >If you are database savvy, you can always get into SQL ...
    (microsoft.public.sqlserver.server)
  • Re: Newbie - Help!
    ... This is my error message: ... CREATE DATABASE permission denied in database 'master'. ... database 'pubs' to file 'D:\Program Files\Microsoft SQL ... I was able to find a trial version of the Enterprise Manager. ...
    (microsoft.public.sqlserver.msde)
  • Re: Recreating database on production machine?
    ... If you want to recreate the database with a script, ... SQL Server MVP ... >I know that you can use the graphical tools in Enterprise Manager to create ...
    (microsoft.public.sqlserver.programming)
Loading