Ok, I wasn't really understanding what he was referring to. Are you saying to place brackets around the "ServerName" in the SELECT statement at the beginning of the procedure?
/* Get a list of the servers to gather data from and their SQL version */
DECLARE ServersCursor CURSOR FOR
SELECT ServerName,
PK,
PersistLink,
SQLServerVersion,
TrackTotalDiskSpace
FROM ServersToCheckDiskStats
I tried putting it in brackets there and the same error occurs. Does the variable @ServerName
need to be in brackets as well? I'm not understanding the posts.
Please bare with me as I am not a T-SQL guru. Thanks for your patience. The script overall is wonderful and is something I've been looking for for a long time.