When installing Sql Server 2000, "The previous program created a pending file operation, and you must restart your computer to run the installer", which is still invalid after restarting.

Solution:

1. Switch to the desktop directly without exiting Sql Server 2000 Setup.

2. Open the registry editor (just type "regedit" in "Run" and press enter) and find the HKEY _ local _ machine/system/current control set/control/session manager node of the registry.

3. Click the "Session Manager" node, then find the "PendingFileRenameOperations" option in the window on the right, double-click to open it (or right-click to select "Modify"), and then delete (empty) the value in the blank column below it.

4. Close the Registry Editor, switch back to Sql Server 2000 Setup, take a step back, and then click Next to solve the problem!

Frequently asked question 2:

During the installation of SQL Server 2005 or SQL Server 2008, the consistency check of performance counter registry hive failed.

Solution:

1. Open the Registry Editor and navigate to HKEY _ Local _ Machine/Software/Microsoft /Windows NT/ Current Version/Performance Library of the Registry.

2. Find the last counter and the last help in it. The values of Last Counter and Last Help are dynamically assigned by Windows, and these two values will vary from computer to computer.

3. The value of the last counter in the previous step must match the maximum value of the counter item of [HKEY _ local _ machine/software/Microsoft /Windows NT/ current version/performance library /004]. And the last help in the previous step must match the maximum value of the last help item in [HKEY _ Local _ Machine/Software/Microsoft/Windows NT/Current Version/Perflib/004].

Note: 004 is an example of simplified Chinese. If the English version is installed, it should correspond to [HKEY _ local _ machine/software/Microsoft /Windows NT/ current version/performance library /009].

4. Close the Registry Editor and run the installation program of SQL Server again. There should be no problem.

Frequently asked question 3:

After Sql Server 2000 is installed, the service cannot be started, and the prompt box "Setup failed to configure the server" pops up. Refer to the server error log and c:\windows\sqlstp.log for details.

Solution:

1. Open the Registry Editor and delete all information about Microsoft sql server under current_user and local _ machine/software/Microsoft/.

2. Delete the installation directory and the Microsoft SQL Server folder under C:/Program Files.

3. Change all computer names to capital letters. (This problem belongs to a bug of sql server. Use GetComputerName to get the local computer name. The Client Network Library component (DBMSLPCn.dll) converts all names to uppercase. The server network library component (SSMSLPCn.dll) retains the name when it returns. When the Windows computer name contains uppercase and lowercase letters or two lowercase letters, the installation will fail, prompting a general network error! The solution is to change all computer names to uppercase! )

4. Restart the computer and install it.

Frequently asked question 4:

There is an empty database in the database, no name, no table, no user, no role in the enterprise manager ... it cannot be modified or deleted. When you use Enterprise Manager, when you create a new table, an error prompt will pop up:

An unexpected error occurred during this operation. [Microsoft SQL-DMO (ODBC SQLSTATE: 42000)]-You cannot use an empty object name or column name. If necessary, please use spaces.

Solution:

1. Before allowing direct modification of the system directory, open the SQL property panel and select the check box! Then click OK to exit.

2. open the master database, find the sysdatabase table inside, find the database with problems, and delete the problem to solve!