search

amachanic / sp_whoisactive

sp_whoisactive
GNU General Public License v3.0
1.17k stars 289 forks source link

Add server_name column to output #44

Closed jahveman closed 3 years ago

jahveman commented 3 years ago

We plan to use the sp_WhoIsActive procedure to collect and log activity information from Azure databases across multiple Azure SQL servers into a single table in the administrative database. It would be great if sp_WhoIsActive could return @@SERVERNAME in the output, so that you can determine not only a database where the procedure was executed, but also a server name.

amachanic commented 3 years ago

My general suggestion here for years has been to use the output options and put the @@SERVERNAME into your output temp table, or make your collection script simply add it to the tabular output. Are either of those workarounds not doable in your scenario, for some reason?

erikdarlingdata commented 3 years ago

@jahveman haven't heard back from you in a while on this, so I'm gonna close it out for now. If you decide you'd like to work on this, let us know and we'll re-open it.