Saturday, February 25, 2012

DBs, sizes etc

Anyone here with a ready to go sqlscript that lists all db's, files, sizes, owner etc? I guess it's a combination of sp_databases, sp_helpdb and sp_helpdb [db].There are scripts out there that will do this for you.

Be aware of how they report db sizings etc.|||www.sqlservercentral.com has all kinds of them. Registration is free. You can go to the scripts area and download to your heart's content.

No comments:

Post a Comment