I'm also using SQL 7 and I ran into the same problem with the local
Enterprise Manager not being able to open tables using 'Return all rows' or
using 'Return Top...'. Enterprise Manager on another computer works fine
when opening the same tables. I tried to install SQL 7 Service Pack 2(SP2)
to see if that would fix the problem.
The SP2 installation did not complete successfully. It seemed to update
the database engine but failed when trying to run some scripts. The error
message I got was "Error running script: upgrade.sql(1)". I clicked OK and
the installation seemed like it was trying to continue for a few (15?)
seconds before another dialog box appeared with the message "An error
occurred when running the upgrade to your server.". I click the OK button
and the installation is finished.
Enterprise Manager now is able to open the tables. I wonder if the problem
is going to come back like it did in Aylon Glaser's installation. Also, the
Is my server stable right now with a "partial" install of SP2? Does anyone
know why the SP2 installation did not complete successfully? Someone did
install IIS on the SQL server machine at some point. Could that have broken
Enterprise Manager?
> I hate to say it, but I am experiencing the same problem. I am unable
> to restart my box so I am stuck right now.
> > We are also experiencing this error, also connecting with pcanywhere.
> > It was working fine for many months, today I tired it, and it doesn't
> > work!
> > > Hi,
> > > We're getting the same errror here. Using the query analyzer to
> return
> > > essentially the same data as a "return all rows" would, we don't get
> > the
> > > error. We found that restarting the server causes the error to go
> > away, but
> > > it reappears after a few days. This is unacceptable as the 5-10
> > minutes it
> > > takes for the server to come back is not fast enough in our mission
> > critical
> > > environment. I couldn't find a fix on technet.micro..com.
> > > Does nayone know what is wrong?
> > > Thanks,
> > > Aylon Glaser
> > > >When trying to 'Return All Rows' from any table (from inside the
> > Enterprise
> > > >Manager) I get this error:
> > > ><error message>
> > > >An unexpected error happened during this operation.
> > > >[Query] - Query Designer encountered a Query error: Unspecified
> error
> > > ></error message>
> > > >I'm using pcAnywhere to connect to the server. I am not the admin
> > but have
> > > >admin rights and permissions. I do not know if a SP has been
> > recently
> > > >installed on SQL 7.0. Could this be the problem? How do I find
> out
> > which
> > > >SP has been installed? Query Designer works fine. I need to be
> > able to
> > > add
> > > >data to the tables using the Enterprise Manager for testing
> purposes.
> > > >Any help would be much appreciated!
> > > >Thanks,
> > > >Carl Jackson
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> Sent via Deja.com http://www.deja.com/
> Before you buy.
by