Per our monitoring scripts i am thinking to add monitor the status of VLF for each database across different SQL servers in our organization:
We have mix of servers from 2012 to 2019: I've found a really good script here https://www.sqlserverscience.com/tools/detect-databases-high-vlf-count/ but there is a problem with which i need some inputs on how to achieve above
The login which executes any scripts across those 100's of SQL server is not a sys-admin. I know there is a way here https://learn.microsoft.com/en-us/sql/relational-databases/tutorial-signing-stored-procedures-with-a-certificate?view=sql-server-ver15 -- but this seems tedious as i think it would need a change across the servers where i would like to run the script
Is there a way i can execute the script with non sys admin privilege to get the VLF info from SQL servers 2012+?