Todays Question of the Day: How to find the free space in Database files?
You must have faced a space crunch issue, when you actually wanted to know how much free space is available in a DataFile for a particular DB, This script will provide you all this info:
NAME = left(a.NAME,15),
FILENAME = left(a.FILENAME,30)
The Script will provide you how much space is actually being used and how much is still available for it to grow further.