Thanks Venkat & SSC for quick and prompt answere

You can use DBCC SHOWFILESTATS WITH NO_INFOMSGS. It will provide you the file_id_, file_group, total_extents, used_extents, File name, file_Location)

Thanks

Neeraj

Thanks for suggestion. But, I don't want to tax trading production system for rare occurrence by continuously running profiler due to (4% - 18%) overheads.

This script is not providing aliased DBO (SQL 2000) in any database, if we can incorporate that code too...it will be greate

--Neeraj