by Raj Paruleka » Thu, 22 Mar 2001 05:00:09
I tried looking for a solution to this on Microsoft's web site but did not
find any thing. Does anyone kinow why this is happening and can advise me on
a potential resolution?
Thanks.
Raj
by Bill Jasiewsk » Thu, 22 Mar 2001 06:00:49
This has happened to me. I did two things that fixed it, and I'm not sureQuote:> When I right click on a table in my database using Enterprise Manager and
> select "Open Table - Return All Rows", I get an Error dialog box stating
"An
> unexpected error happened during this operation. [Query] - Query Designer
> encountered a query error: Unspecified Error".
Stripped the MDAC from the computer and re-installed, then...
Un-installed the SQL tools (like Enterprise Manager, Query Analyzer) and
re-installed.
That fixed it for me.
by Raj Paruleka » Thu, 22 Mar 2001 07:29:35
Quote:> > When I right click on a table in my database using Enterprise Manager
and
> > select "Open Table - Return All Rows", I get an Error dialog box stating
> "An
> > unexpected error happened during this operation. [Query] - Query
Designer
> > encountered a query error: Unspecified Error".
> This has happened to me. I did two things that fixed it, and I'm not sure
> which,
> or if it was a combination of the two.
> Stripped the MDAC from the computer and re-installed, then...
> Un-installed the SQL tools (like Enterprise Manager, Query Analyzer) and
> re-installed.
> That fixed it for me.
Hello all
I've got SQL Server 7.0 SP1 installed (in a NT4 SP6 environment).
Recently, it came up with error whenever I try to open a table or a view
(return all rows) inside the Enterprise Manager. The descriptive (NOT!)
error message is like this:
"The query cannot be executed because some files are either missing or
not registered", and on pressing "help",
the help files report
"Query Designer cannot locate your query files and cannot run your
query"
I have tried re-booting the machine and upgrading mmc.exe to version 1.2
(from 1.1), but both in vain.
Can anyone shed some lights please?
Simon
Sent via Deja.com http://www.deja.com/
Before you buy.
2. SQL Backup
6. questions on size & performance
9. Query designer error message
10. Query Designer Error - Cannot open tables...
11. Enterprise Manager -> Query Designer Error
13. SQL 7 Enterprize Mgr. Query Designer Error