Upgrade SQL Server 2000 Personal Edition to SQL Server 2000 Standard Edition
Posted on 2009-05-06
One of our engineer mistakenly installed SQL Server 2000 Personal Edition in our customer server.
While the requirement should be SQL Server 2000 Standard Edition.
And we just found out recently because the customer complained that the server is slow. From the Event-Viewer it is clearly shown that the Personal Edition is limited to 8 concurrent queries, while the number of actual concurrent queries are more than 8.
Do you have a step-by-step how to upgrade to SQL Server 2000 Standard Edition? I mean really step-by-step instruction. Keep in mind that there are production databases (Lets call them DB1, DB2, DB3).