I need to update a SharePoint list whenever a datachange happens in the sql cuastom table. I am trying achieve this by writting a trigger in the sqltable and calling PowerShell script to update list in the trigger.
Can anyone tell me the syntax to call the PowerShell script in the trigger?
i was using tthe command below for executing the PowerShell script in sql
xp_cmdshell 'c:\change.ps1 -Application_Number 100'
It gives me an error c:\change.ps1 is not recognized as an internal or external command