Thanks Fritchey

Hello Grant Fritchey

Thanks for your reply

Your right if we go with MS license get the media we can perform easily but

My question is customer want go with google license(on demand)...

Thanks above link related to CLoudsql(fully managed)

Any idea how to upgrade in VM(compute engine) sql express to sql standard edition

I will appreciate your help

For database information for all databases

create table #dbsize

Hello Team,

I am using below query to get size_mb and unused space in database

Is there any way to get instance level or report ?

Query:

select

a.FILEID,

[FILE_SIZE_MB] =

convert(decimal(12,2),round(a.size/128.000,2)),

[SPACE_USED_MB] =

convert(decimal(12,2),round(fileproperty(a.name,'SpaceUsed')/128.000,2)),

[FREE_SPACE_MB] =

convert(decimal(12,2),round((a.size-fileproperty(a.name,'SpaceUsed'))/128.000,2)) ,

NAME =...

Thanks anthony

I have removed '& # x 0 D ;' in script it is not working

Can you please give me modified script

Thanks gail

Thanks it is working

Thanks

Thanks Graeme

Thanks a lot andy

Thanks

Got it Jo Thanks alot your help

Thanks Jo you want me to change any settings in distribution properties.

Thanks Jo