Hello,
I have installed system center 2012 SP1 anf SQL server 2008 in another server. I have a problem with SMS_POLICY_PROVIDER component.
Microsoft SQL Server reported SQL message 266, severity 16: [25000][266][Microsoft][SQL Server Native Client 11.0][SQL Server]Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count
= 1. : sp_UpdatePolicyTargetingMap
Please refer to your Configuration Manager documentation, SQL Server documentation, or the Microsoft Knowledge Base for further troubleshooting information.
in policypv log
*** exec sp_UpdatePolicyTargetingMap 16777230 SMS_POLICY_PROVIDER 18.10.2013 09:48:17 6348 (0x18CC)
*** [42S22][207][Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'CollectionID'. : sp_UpdatePolicyTargetingMap SMS_POLICY_PROVIDER 18.10.2013 09:48:17 6348 (0x18CC)
*** exec sp_UpdatePolicyTargetingMap 16777230 SMS_POLICY_PROVIDER 18.10.2013 09:48:17 6348 (0x18CC)
*** [25000][266][Microsoft][SQL Server Native Client 11.0][SQL Server]Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1. : sp_UpdatePolicyTargetingMap SMS_POLICY_PROVIDER 18.10.2013
09:48:17 6348 (0x18CC)
UpdatePolicyTargetingMap: could not process the Updated Policies SMS_POLICY_PROVIDER 18.10.2013 09:48:17 6348 (0x18CC)
who can tell how to fix this error?