Geeks With Blogs
SharePoint & SQL Thoughts June 2011 Entries
All databases storage information
SQL Tidbits Have you ever had a need to see storage information for all your databases in a SQL Server? As they say there are many ways to skin a cat all based on your need. Back in the day I was taught to use SYS.SYSFILES, its handy and it does give you what you need but suppose you wanted a picture of your entire SQL Server? Then this solution is not viable that’s when we divert to SYS.MASTER_FILES according to MSDN http://msdn.microsoft.com/e... this system view contain ......

Posted On Wednesday, June 8, 2011 11:02 PM

Copyright © Leonard Mwangi | Powered by: GeeksWithBlogs.net