In SQL Server 2008, to see all available db backups: select * from msdb.dbo.backupset

This is an easy way to get all rows from a SQL table into a string: select stuff(( select ‘, ‘ + a_column from [name_of_table] order by table_id for xml path(”) ), 1, 1, ”)