I. SQL Server patch version check SQL Server patch version check is not as direct, a system administrator, if you don't know the patch number of the SQL Server version, may also encounter a bit of trouble, so this explains It is a safe way to discriminate the machine by this method, and there is no impact on the system. 1. Log in to SQL Server with the ISQL or SQL query analyzer. If you use ISQL, enter ISQL -U SA in the CMD window, then enter your password, enter; if you use the SQL query analyzer, start, enter, enter SA and passwords (you can also verify using Windows). 2, enter: select @@ version; Go or SQL query analyzer input (actually if you don't want to enter, as soon as you open your help, you can select @@ version; then press down; then return to SQL version Information, as follows: Microsoft SQL Server 2000 - 8.00.760 (Intel x86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 3) 8.00 .760 is the version and patch number of SQL Server. The correspondence is as follows: 8.00.194 ------- SQL Server 2000 RTM 8.00.384 ------- (SP1) 8.00.534 ----- - (SP2) 8.00.760 ------- (SP3) so we can see the correct version and patch number of SQL Server. We can also see more detailed information with XP_MSVER. Second, patch installation In the process, the FAQ If you encounter a similar error when installing the patch: 1. "The previous program created a hang-on file operation during the installation process, before running the installer, you must restart", follow these steps to solve : A, restart the machine, then install, if there is still this error, press Step B, enter RegeDit C in Start -> Run to HKEY_LOCAL_MACHINE / SYSTEM / CURRENTCONTROLSET / Control / Session Manager Location D, select File - > Pour out, save E, right-click PENDINGFIELENAMEOPERATIONS, select Delete, then confirm F, restart the installation, problem solving If there is also the same problem, check if there is this value in other registry, if you have deleted.
