SELECT [Name] = d.[name] ,[State] = d.state_desc ,slo.* FROM sys.databases d INNER JOIN sys.database_service_objectives slo ON d.database_id = slo.database_id order by d.Name
alter database [MyDatabase] modify (service_objective='Sn')
ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2024, Patrick Jasinski.