Hi Team,

I want all Databases Size in my instance can any body please provide the script.

Tx

Hi,

Try 'sp_helpdb'.

Thanks,

Stephen

• Proposed as answer by Abhay_78 Thursday, July 28, 2011 2:33 PM
• Marked as answer by Alex Feng (SQL)Moderator Thursday, August 04, 2011 11:05 AM

Hi,

Try this...

EXEC sp_MSforeachdb 'USE ?; exec sp_spaceused'

Try this link for three different ways to get database sizes.

Get the Database Sizes in a SQL Server