Well, coding a table maintenance job for 140 different servers which are from 2005 to 2019 version, with a reporting server or not, with sdt or not, it is very...

Hi,

A small improvement to this script may be :

SELECT @InstanceName = convert(varchar, ISNULL(ServerProperty('InstanceName'),'MSSQLSERVER'))

(Since the return value may be null when default instance name is used)