PowerShell to track the changes in the sql server database table values RRS feed

  • Question

  • Hi

    We have upstream system which populates table with specific values. I need to constantly determine the value in the SQL server Database table and based on the change so I can call a update statement.

    I want to achieve this by using PowerShell script.I am wondering if I use a loop which runs every one second and search the value of the table it will consume memory resources. Does PowerShell have any other means to achieve it. Something like remote receiver or hook which can be used as an optimized way instead of creating endless loop/



    • Edited by Rajaniesh Kaushikk Friday, July 6, 2018 11:08 PM
    • Moved by Bill_Stewart Wednesday, September 5, 2018 10:07 PM Unanswerable drive-by question
    Friday, July 6, 2018 8:46 PM