Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
robwinter
Starting Member
2 Posts |
 Posted - 2002-08-06 : 08:12:43
|
| Hello Everyone!Since yesterday I got a problem when I try to open a table in SQL enterprise manager.The steps I take are the following:I open the SQL enterprise manager on the serverI choose a SQL database, I choose for tables, I select a table, do Open table and Return all Rows.When I do that I get the following error statement:An unexpected error happened during this operation[Query]- Query designer encountered a query error: Unspecified error.Do any of you have a clue what this error means?Thank you for your time.Rob |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-08-06 : 08:48:45
|
Yeah, don't you just love those REALLY EXPLICIT error messages?  Makes troubleshooting so much easier.If it happens to any/every table, then it's definitely an EM problem. The best way to check is to open Query Analyzer and try a SELECT * FROM myTable and see if it works (try a couple of tables)To fix it you should try reinstalling the client tools on the machine. Is this the SQL Server itself, or are you doing thing from another computer? If it's the server, and the only thing that's not working is opening a table, I wouldn't worry about it. EM is not a good tool for browsing and editing data anyway, you really should use Query Analyzer or another tool for that (like MS Access with linked tables) |
 |
|
|
robwinter
Starting Member
2 Posts |
Posted - 2002-08-06 : 10:23:29
|
| It happends to any/every table on the server. and the only thing not working is opening tables.I will try your suggestion first think in the morning!thanks! |
|
|
|
|
|
|
Error when trying to open a table