Update script help needed

[chercm]

I am using mid server and using sql authentication to connect to the badge sql server to pull in all the user badge number and update in the user_badge table . The db is having all active cards but the request is to pull the badge changes like when the user gets a new badge when lost or damaged . What is the best of doing this ???

[Viraj Hudlikar]

Hello @chercm 

I am not sure with exact requirement but here are some link which will be helpful to you:
Track Data Changes - SQL Server | Microsoft Learn

How to track data changes in a database table - Stack Overflow

If my response has helped you hit helpful button and if your concern is solved do mark my response as correct.

Thanks & Regards
Viraj Hudlikar.

[chercm]

@Viraj Hudlikar  i am using the badge integration to allow the user badge to tap at the techbar to open ims ticket 

what script can i use to connect to the db to perform the update on the table on sn ?