Summary:
ERROR IN WINDOWS NT APPLICATION LOG:

"Event ID (1001) in Source (SQLCTR70) Could Not Be Found"

This error is the result of a known issue with Microsoft SQL 7 and MSDE. All information provided is taken from the following technet article:

Article ID: Q196657
Last Reviewed:
April 15, 1999

Please check with Microsoft for current status.

Symptom:
The information in this article applies to:

Microsoft SQL Server version 7.0

SYMPTOMS
You may find the following error message in the Windows NT event log:
The description for Event ID (1001) in Source (SQLCTR70) could not be found. It contains the following insertion string(s): Specified counter not found in shared memory..

This may indicate problems with the SQL Server 7.0 Performance Monitor counters.

Resolution:
WORKAROUND
To work around this problem, you must remove and reinstall the SQL Server 7.0 Performance Monitor counters. To do this, perform the following steps:

Open a command prompt.

Run the following command to unload the SQL Server 7.0 Performance Monitor counters:

unlodctr mssqlserver

Close and re-open Performance Monitor; the SQL Server counters should now have been removed from the object list.

Run the following command from the command prompt to load the SQL Server 7.0 Performance Monitor counters again:

lodctr c:\mssql7\binn\sqlctr.ini

Close and re-open Performance Monitor; the SQL Server 7.0 counters should now appear in the object list.

If the SQL Server 7.0 counters still do not appear in the object list, close Performance Monitor and stop SQL Server 7.0. Then restart SQL Server 7.0 and open Performance Monitor again.

Status:
Microsoft Article ID: Q196657 -- April 15, 1999

Additional Info:
Microsoft Article ID: Q196657

Original Author: DLANG
Original Submitter: DLANG
Keywords: SQLCTR70 1001 SQL Server 7.0 Performance Monitor counters MMS ID#22023