SQL error message

[OldSkoolSkater]

Hi all

I am totally new to SQL server, but I have this message appear every time I try to open a table from within any database in SQL:

An unexpected error happened during this operation.
(Query) - Query designer encountered a query error;
Unspecified error

I know this mesage is very non-specific and not much help, but any pointers / tips would be greatfully received!

Cheers

 

[rajeevnandanmishra]

Hi SnowDude,
Are you able to do select * from myTable in the query analyzer?

 

[OldSkoolSkater]

Hi rajeevnandanmishra

I am not sure what you mean, I'm afraid!
I am using the enterprise manager to try and open the table, and this is where I get the message.
I opened up the Query analyzer but couldn't get very far in trying to open the table there.

Help me, I'm drowning!

 

[rajeevnandanmishra]

Hi Snowdude,
Open Query Analyzer
While opening it, it asks for the server, userid & password. specifies these as per your condition.
Write the SQL Use myDatabase or select the database from the dropdown combobox on the top.
Write the SQL SELECT * FROM myTable And then run it (by pressing ctrl+E or by clicking on the green run toolbar button).

Let me know if you get any error there.

 

[tlbroadbent]

If you are running SQL Server versioln 7 then you need to know that this is a known problem in SQL 7 Enterprise Manager not SQL Server itself. Rebooting the machine where you run EM should fix the problem temporarily.

Installing SQL 7 SP3 may fix the problem permanently. If you are running a different version of SQL Server or have already installed SP3 then we'll have to search for another reason for the error. Terry Broadbent

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin

 

[OldSkoolSkater]

Hi rajeevnandanmishra

Have tried as you suggest and get the following message:

Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'ZZ_HELP'.

Have checked and the table is definitely there.

 

[OldSkoolSkater]

Hi tlbroadbent

I don't know if SP3 has been applied to SQL 7. The only data I can find is the product version 7.00.623.
I cannot reboot the server at the moment due to the number of people accessing it.
Having had this SQL server dumped on me with no knowledge of how it has been installed or how it works, I feel very stupid and appreciate all of your help.
Thank you

 

[tlbroadbent]

In Query Analyzer (QA) you can run the following code to check the version of SQL Server installed on the server. Your Enterprise Manager (EM) version is probably the same version.

Select @@version

These are the versions of SQL 7.
7.00.623 Original SQL Server 7.0
7.00.699 Database components SP1
7.00.842 Database components SP2
7.00.961 Database components SP3

If you cannot upgrade to SP3 then it seems that the only alternative is to reboot the machine where you run EM. Are you running it on the server or your own PC? If on your own PC, then just reboot your PC. Remember, this is a client rather than a server problem. If you are running on the server, you'll need to find the appropriate time for rebooting.

If you don't have the client tools installed on your PC and you are charged with administering SQL Server, I recommend installing the tools. Terry Broadbent

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin