Re: error opening table in Enterprise MGR

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 01/27/05


Date: Wed, 26 Jan 2005 20:42:35 -0700

Check the following article which addresses the issue:
FIX: Enterprise Manager Returns Unexpected Error on Table or
View
http://support.microsoft.com/?id=273472

-Sue

On Wed, 26 Jan 2005 07:47:03 -0800, "PatW"
<PatW@discussions.microsoft.com> wrote:

>I am getting an error message when I try to open (to view the rows of) any
>table in any of the databases on a SQL 7 server from the server where the
>databases actually reside- it says:
>"An unexpected error happened during this operation. [Query] - Query
>Designer encountered a query error: Unspecified error
>This error is new; I am able to query and get results from the tables in
>query analyzer and I am able to view the tables through Enterprise Manager
>when I link to these databases from another computer. I restarted SQL server
>without any luck. Do you think it needs to be reinstalled?



Relevant Pages

  • Re: Duplicating a database
    ... alternative to get a Query environment. ... on his OLTP, ... MVP SQL Server ... >>> of those databases. ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: How to check if SQL 2000 is installed? (SBS 2003 SP1 Problem!)
    ... > Enterprise manager" and view the databases running on your server (just ... > click the + until you see databases), then you definitely have a SQL ... But I have sometimes installed two Tools called "MSDE Manager" and "MS SQL ...
    (microsoft.public.windows.server.sbs)
  • Re: Enterprise Manager for shared server
    ... Autoclose turned off on your databases as well. ... Andrew J. Kelly SQL MVP ... > that are maintained on this same server. ... > 2-3 minutes for Enterprise Manager to propagate the ...
    (microsoft.public.sqlserver.programming)
  • Re: multi table multi database join?
    ... you could also do this using a "linked server" allowing to perform joins ... the query should likely retrieve results based ... sybase runns on one machine mssql on another, ... the those tables even if the tables are in databases on ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: urgent help with sql
    ... what's weird that evry thing is working fine from the sql ... throught the query, but i will try this MDAC may be? ... Enterprise manager. ... >> at all as i explained i can access all the databases ...
    (microsoft.public.sqlserver.server)