Ansible needs the sudo password to escalate privileges on the remote host. The challenge is getting that password to Ansible without: Storing it in plaintext in version control Exposing it in shell ...
On [!INCLUDE ssNoVersion_md] and SQL Managed Instance, sys.dm_tran_locks requires VIEW SERVER STATE permission. On SQL Database Basic, S0, and S1 service objectives, and for databases in elastic pools ...