Viewing 12 posts - 1 through 12 (of 12 total)
For database information for all databases
create table #dbsize
December 21, 2012 at 1:36 am
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 =...
December 21, 2012 at 1:13 am
Thanks anthony
I have removed '& # x 0 D ;' in script it is not working
Can you please give me modified script
December 18, 2012 at 9:29 pm
Thanks Graeme
November 7, 2012 at 9:45 pm
Thanks a lot andy
November 3, 2012 at 3:20 am
Thanks Jo you want me to change any settings in distribution properties.
October 24, 2012 at 2:49 am
Viewing 12 posts - 1 through 12 (of 12 total)