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