I mean this. Assume I have 2 backup dates for hostname "c" and 3 backup dates for hostname "d". And the table is like that:

hostname last_backup

c ...

Hi,

This is what I get when I run the script.

Column 'xxxx.dbo.backup_database_daily.backupType' is invalid in the select list because it is not contained in either an aggregate function or the...

Now I have another question. I want to check if default port is 1433 or not. If so, when I evaluate the condition I want to see "x" in...

and I think, these code returns all sysadmin groups. I also need to get some of the sysadmin groups. For example I want to check if one desired group is...

Can you explain what you wrote in 'field' part? The part starting with ExecuteSql...