Difference between APP_NAME() and PROGRAM_NAME()

app_name() is certainly better as it does not require any permissions. And if the user has permissions enough, the dm_exec query could return the application name for someone elses application.

---

Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se