# Microsoft SQL server play

**URL:** <https://forum.ansible.com/t/microsoft-sql-server-play/26278>\
**Category:** Ansible Project\
**Created:** [December 13, 2017, 11:05am UTC](https://forum.ansible.com/t/microsoft-sql-server-play/26278 "2017-12-13T11:05:09Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![area0](https://avatars.discourse-cdn.com/v4/letter/a/ccd318/32.png) [@area0](https://forum.ansible.com/u/area0)\
**Post date:** [December 13, 2017, 11:05am UTC](https://forum.ansible.com/t/microsoft-sql-server-play/26278/1 "2017-12-13T11:05:09Z")

</div>

Hi guys,

Just wondering what’s the best way to run an SQL UPDATE on a remote Microsoft SQL database; the idea is that, once a machine runs through the win\_updates module, a field in the SQL database called ‘last patched’ is updated to the current day/time.

Am i looking at the command module with DSN/username/password in the playbook?

Thanks guys
