Unspecified Error when Return All Rows of table

[KevyD]

My SQL Server 7.0 has been screwed up from the get go.

I've got SP4 on it now, still with same problem. Win2000 Advanced Server with I think all the recent windows updates.

When I try to open a table "Return All Rows", any table (even in the Northwind sample), I get "Unspecified Error" and it does not show me the data.

On subsequent tries, I get "Catastrophic Failure".

Stopping the service and starting doesn't help. Rebooting doesn't help. For some reason, it has never worked.

Kevin

 

[tlbroadbent]

Are you referring to opening the table in Enterprise Manager? Can you access the full table from Query Analyzer with a query such as Select * From table_name? Does the error occur on one, a few or all tables? Is the client software up to date? What Network Library is being used?

It really does sound like a client error rather than a SQL Server error. However, an error on the server may cause failure of the client. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[aalmeida]

Try re-installing Enterprise Manager onto the client AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"

 

[KevyD]

Oh, shoot, I forgot I posted to this forum! Sorry, guys.

Yes, I am trying to open table from Enterprise Mgr. Query Analyzer does not work either. I have removed and reinstalled entire SQL Server 7.0, without fixing the error. I've put on the latest SP and latest MDAC from Microsoft. Nothing fixes it, and I am suspecting that it is the machine itself.

This machine has been a problem child no matter what OS has been installed on it. So I think I'll replace it with another and see if it helps. Good thing I'm not using XP! How would you explain that to the product activation police? But that's another discussion...

KD

 

[tlbroadbent]

KD,

I recommend that you join Tek-Tips rather than continuing to post as a visitor. It is free and there are several benefits to membership including email notification of replies to your posts and easy access to all posts that you have made. No more forgetting! %-)
Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[aalmeida]

Yeap!
I agree with Terry AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"

 

[KevyD]

I'm official now!

However, this problem with SQL server on the back burner right now.

Thanks for your advice

 

[KevyD]

Well, I threw it all on a different machine and ended up getting the same error!

But this time, after installing all the SQL server updates, it starting working correctly!

I don't understand it, but now it works. That's good enough for me!

Kevin