T-SQL only Solution for gathering disk size info?

Question

T-SQL only Solution for gathering disk size info?

Viewing post 16 (of 15 total)

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

WayneS SSC Guru Points: 95460 More actions · Answer 1

Jeff, you might be able to use this article[/url] to do it.

Also, can you get this information if you were to use xp_cmdshell? You could enable/disable that just like the ole automation procs in my earlier script. Or if you want to be really safe, always disable it when you're finished.

Keep us informed.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2