Use this:
exec master.dbo.sp_msforeachdb "exec [?].dbo.sp_spaceused"
For more information please go to the below link:
http://www.sqlservercentral.com/articles/Administration/2771/
I am related to Software Industry working as SQL Database Administrator, so I have created this blog to collect useful information about my area of work. It may contains references to stuff published somewhere else on internet [with full regards to the publisher, of course] and also some of my own. I will also post some out of the box stuff too, if I find it interesting.
No comments:
Post a Comment