Databases

Database

Tags:Microsoft Sql Server

There is some problem with the server's hard disk. I copy the database backup file to a new position in the server. When I attach the database I got an error prompt of Microsoft Sql-DMO 823 errors. View Log as follows:

Error: 823, Severity: 24, State: 5.

I know this may caused by the damage of a database file or hardware. I try the following steps to fix the database and got succes.

Assumes that the database name to be fixed is "mydb", then:

1. Run MS-Sql...

Database - Sql Server

Question:
When I running the Microsoft sql server enterprise manager, it raise an error of "SQLDMO has not been registered, please re-run SQL Server setup and  contact  your system administrator." What is the problem. My sql server has already been installed and it runs very well until today.

Answer:
To solve this problem is an easy way. That is, at the Command prompt, run this command line: regsvr32 sqldmo.dll. Well, notice that if the command can not be successfully executed, then you...

Database - Sql Server

Tags:Microsoft Sql Server

When you need to connect to a remote sql server, you could register a remote server in your sql anterprise manager. On the console root, expand the Microsoft SQL Server, right click "SQL Server Group", select "Create New SQL Server Register", then on the prompt dialog click "next", input your remote server ip in the available server text box, then add it to the right servers list. Click "next" button to continue, select one way of identify to log on the SQL Server...

Database - Sql Server