Did you ever figure out what the problem was? I am having the same
issue but only on one client running enterprise manager. I have even
gone so far as to completely uninstall and reinstall. If anyone has any
info, please reply or send me an email at
Originally posted by Dave
to re-install SQL Server or even Windows 2000Quote:> I can find no reference to this error anywhere!
> When I try to access any table using Enterprise manager ON THE SERVER
> with an "Open
> Table > return all rows" I first get the message "Unspecified error"
> (nothing else),
> if I try the same again (refresh "!") I get "Catastrophic failure"
> I can access the data through the SQL Query Analyser on the server or
> Manager installed on a client machine and get back the data required.
> This is a SQL Server 2000 database (Std Edition) that I have just set
> up on a new
> server running Windows 2000.
> I tried the service pack (2) as I thought something may have gone
> wrong with the
> install and that this might correct it - still the same.
> I don't want to continue updating the database if someone is going to
> tell me I have
Posted via http://dbforums.com