The postings on this site are my own and do not represent my Employer's positions, advice or strategies.

LifeAsBob - Blog



No Ads ever, except search!
Monday, May 27, 2024 Login

Blog posts for the month of May,2019.
SSMS Database properties error subquery more than 1 value5/16/2019 10:40:17 AM

SELECT DB_ID(database_name) AS [db_id(database_name)] , database_name, backup_start_date, machine_name FROM msdb..backupset WHERE type = 'D' ORDER BY 1, 2;

SSMS 18.0 GA, pulling up properties of a database for a managed instance.

Blog Home