Tweet

Hi all,

If you have issue with smsexec.exe process and that your smsexec.exe is 100% process processor use, you can:

Open SQL Server Management Studio and disable ‘No count’ and processing will continue normally.

The « No count » option can be found in the SQL Management Studio:  Properties of the SQL Server -> Connections -> ‘no count’.  It should be unchecked.

SCCM2007 Source

For issue with SMS2003, see this link

related post

• System Center Service Manager (SCSM) 2010 is available in RTM !
• Cumulative Update package 7 (CU) for SQL Server 2008 R2 is available!
• New Microsoft Ebooks Windows 7, SQL, Office 2010, Virtualization and others: List of our free books, available for download !!!
• Cumulative Update #14 for SQL Server 2008 Service Pack 1 (Prerequisite for repair SQL replication Database between servers SCCM 2012)
• How to install (update) Windows Automated Installation Kit (WAIK) for Windows 7 SP1 on Windows Server (existing WAIK installation)