FWIW, for both the vendor of this forum software (InstantASP) and the  few others we've talked to, this is the longest thread anyone has ever seen.

If you want driving, you want an API of some sort. Roads aren't easily calculated in SQL without lots of data. If you just have zip codes, you'll get straight...

have to be careful here Serveradmin gives you some stuff. Not sure to the extent they can get to xp_cmdshell, but if you can change the registry, you can really...

As Lynn mentioned, dynamic SQL is needed.

declare @cmd varchar(max)
-- set cursor
set @cmd = 'select ... from ' + @dbame + '.sys.objects'
-- stuff
exec(@cmd)

I'd dig through any that have log larger to be sure that backups are running, verify this and audit to determine why. I've had a few with larger logs, that...

you need to query sysobjects (and other system dbs) in that database.

as in select * from mydatbase.sys.objects.

Here's a basic query. It produces rows, but you get the ROWs and LOG information for each database.
SELECT d.name AS databasename,
   f.type_desc,
   SUM(size) AS totalsize

Some of these have nothing to do with clustering or AGs.

1. What's your RPO/RTO? In other words, how much data loss and how long can you be down?...

If you are trying to backup the database, it must be available. If you have log shipping, you cannot make a backup of a database in standby or norecovery mode....

I wouldn't write this anymore. It's too hard to manage the data, keep the queries up to date, and it becomes a job. I would rather use a tool of...

Definitely check IO, as Sue suggested. The system is having trouble reading drives. I'd also run DBCC CHECKDB ASAP on this database. There might be other issues. If you have...