April 7, 2005 at 3:39 am
An unexpected error message is coming when trying to open table in database. The sql server 7 was installed on a windows NT machine, that was upgraded to windows 2000. The databse backups were taken, successfully from sql server before upgrading the OS. Now,reinstalled SQL server on win 2000, restored the database.
The problem is SQL server showing databases, but not opening tables..Unexpected error occured message box is shown..
Please help
April 8, 2005 at 7:25 am
Is there any messages in the event log/ or SQL logs? Did you try to issue a select from QA? What happens if you connect to the DB from a remote machine with QA and EM?
Did you try running a DBCC CHECKDB to ensure all is ok with the DB restore?
April 8, 2005 at 9:37 am
From the way you described the initial problem I'm guessing that you fail to open tables in EM. If this is in fact the case, have you tried OSQL ? Other thoughts ... Is this on the database server or on a client computer ? Have you tried EM and OSQL on the database server ? Have you tried EM and OSQL on one or more client computers ? Does the application still work ?
These are a number of simple self diagnosing tess that would only take a few minutes. These simple tests do not replace nor eliminate the need to view the system/application/security event logs on the affected database server or client software computer(s) nor a thourough examination of the SQL Server error log(s).
Also, what is the exact OS and SQL Server versions ? Are the Server and Client computer(s) on the same version ?
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply