7. How do I determine that the SQL SERVER 2000 database has SP4 patches installed?
(1) Desktop bottom left corner "start"-"All Programs"-"Microsoft SQL Server"-"Enterprise Manager". As shown in the following:
(2) Double-click "Microsoft SQL Servers"-"SQL Server Group" until "(local) (Windows NT)" appears. As shown in the following:
(3) Right-click "(local) (WindowsNT)"-"Properties". As shown in the following:
(4) in the "General" tab "product Version" shown as (SP4) means that the SP4 patch has been installed, if shown as (RTM) that is not installed patches. As shown in the following:
(5) In addition we can use the DOS command to view, the specific steps are as follows: A, click on the bottom left corner of the computer "start"-"Run"-Enter the cmd point "OK". As shown in the following:
b, enter osql–e and press ENTER. As shown in the following:
C, enter SELECT @ @version and press ENTER. As shown in the following:
D, enter go and press ENTER. As shown in the following:
E, shown here 2039 indicates that the patch has been patched. As shown in the following:
How do I determine that the SQL SERVER 2000 database has the SP4 patch installed?