I want to list all user databases size in central managemnet server

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 1

You could use the following,

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Jayanth_Kurup SSC-Insane Points: 22967 More actions · Answer 2

Might want to add the state_desc & recovery model to the above list as well.

select * from sys.sysaltfiles

Gives you the size per database

Shows you how to execute a query against more than 1 instance at a time

Jayanth Kurup[/url]

Sgar... SSCarpal Tunnel Points: 4409 More actions · Answer 3

create table test

([name] sysname,db_size nvarchar(13),

[owner] sysname null,[dbid] smallint,

created nvarchar(11),[status] nvarchar(600),

compatibility tinyint)

insert into test exec sp_helpdb

select name ,db_size,owner from test where name not in ('master','model','msdb','tempdb')

exact answer...

Sagar Sonawane
** Every DBA has his day!!:cool: