This article was previously published under Q125668
This article has been archived. It is offered "as is" and will no longer be updated.
SMS Administrator can log its activities to a log file (a process known astracing). By default, tracing is turned on for SMS Administrator, but thelog file does not get created until SQL Server tracing is turned on.
To turn on SQL Server tracing:
WARNING: Using Registry Editor incorrectly can cause serious, system-wideproblems that may require you to reinstall Windows NT or Microsoft SMS tocorrect them. Microsoft cannot guarantee that any problems resulting fromthe use of Registry Editor can be solved. Use this tool at your own risk.
Start Registry Editor (REGEDT32.EXE) and select the HKEY_LOCAL_MACHINE subtree.
Go to the following subkey:
From the parameter list, select SqlEnabled.
From the Edit menu, choose DWORD.
In the Data field, change the value from 0 to 1 and then choose OK.
To verify that tracing is enabled for the SMS Administrator User Interface, go to the following HKEY_LOCAL_MACHINE key:
A UI.LOG file is created in the SMS\LOGS directory. The log file can beviewed using SMS Tracer (SMSTRACE.EXE). For more information on using SMSTracer, query on the following words here in the Microsoft Knowledge Base: