1

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

0

You can create a small Stored Procedure and create a Trigger within, to execute the PowerShell (1.0 or 2.0) script using xp_cmdshell. Here is a small example on how to do it

P.S. But I sincerely hope that you won't manipulate directly with SharePoint related configuration or content databases since it is not supported by Microsoft.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.