Navigation

	Home Page
	Index
	All Pages

Contributor Links

	Create a new Page
	Administration
	File Management
	Login/Logout
	Your Profile

Other Wiki Sections

Software

Databases and Their Service Objectives - SQL Azure

Getting¶

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

Changing¶

alter database [MyDatabase] modify (service_objective='Sn')