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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-02-05 : 07:16:26
|
| Sami writes "SQL Server 7 (French edition) running on WinNT Server SP6I am able to access 'SELECT' all tables using Query Analyzer or any ADO based client. However, trying to open a table locally with Enterprise Manager displays an error dialog stating :'Une erreur inattendue s'est produite au cours de cette opération. Le concepteur de requêtes a rencontré une erreur Requête: Erreur non spécifiée'Which internationaly would mean :'An unexpected error occurred. The query designer encountered a query error: Unknown Error'- Is this a known problem with SQL Server ?- Does this mean reinstalling SQL Server ?Note: Application running in an FDA regulated environment. Access to the server physically and logically is very restricted. Server is RAID5 and SQL Server has been operating for about 2 years with no major problem." |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-02-05 : 07:56:04
|
| It's probably not a sql server problem just an enterprise manager error.You might have to re-install the client tools or apply the latest service pack - but better just to not use enterprise manager.If you are trying to use the query designer then it's better to write them in query analyser.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2004-02-05 : 18:45:45
|
| Usually a reboot fesolves this issue. I think MDAC is the root cause if I remember correctly.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
|
|
|
|
|
|
Error while accessing tables from Enterp. Mngr