Add server_name column to output
jahveman opened this issue · 2 comments
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.
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?
@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.