Microsoft KB Archive/139141

= Debugging SMS/SQL Related Problems =

Article ID: 139141

Article Last Modified on 10/27/2006

-

APPLIES TO


 * Microsoft Systems Management Server 1.0 Standard Edition
 * Microsoft Systems Management Server 1.1 Standard Edition
 * Microsoft Systems Management Server 1.2 Standard Edition
 * Microsoft Systems Management Server 2.0 Standard Edition
 * Microsoft Systems Management Server 2.0 Service Pack 1

-



This article was previously published under Q139141



SUMMARY
Microsoft Systems Management Server uses SQL Server extensively. Therefore, it is necessary that you diagnose connection or access problems to SQL Server on a regular basis. You may also need to manipulate data stored in the SQL Server.



MORE INFORMATION
A common function used to access SQL Server is the ability to log each SQL command into the existing SMS trace logs. "Select" or "update" statements appear as they are issued, which may slow down performance. To enable this function:

WARNING: Using Registry Editor incorrectly can cause serious, system-wide problems that may require you to reinstall Windows NT to correct them. Microsoft cannot guarantee that any problems resulting from the use of Registry Editor can be solved. Use this tool at your own risk.

 Run Registry Editor (REGEDT32.EXE).  From the HKEY_LOCAL_MACHINE subtree, go to the following key:      \SOFTWARE\Microsoft\SMS\Tracing  From the Edit menu, select Add Value.  Add the following: Value Name: SQLEnabled Data Type: REG_DWORD Data: 1  Choose OK and quit Registry Editor. Shutdown and restart Windows NT.</li></ol>

Some SMS service components may need to be restarted for the change to take effect.

Additional information is also available directly from SQL Server itself. By running i/SQL and issuing the following, the SQL\LOGS\ERRORLOG.* file(s) will also be updated with the commands being issued by each application: dbcc traceon(-1,4032,3605) This configuration can be toggled off and on as follows: dbcc traceoff(-1)

-or-

dbcc traceon(-1) These settings should not be active for normal use of the system and are intended for debugging purposes only. Once you obtain output in the respective log files, they can be used to determine more closely what is happening.

Additional query words: prodsms sql trace tracing

Keywords: kbnetwork KB139141

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.