I get alerts for a particular file getting full from BMC Patrol.
Though this file is a part of a filegroup and it contains many other files in that filegroup which are not full with data.
When i use sp_spaceused i get information abt the whole database.
When i check the code of this procedure it gets the data from sysindexes table.
Though this tabel does not contain the file id, but it contains the filegroupid.
Can any one tell me how to find the actual data and free size for a particular file in filegroup