>I am a FoxPro developer but sometimes my boss asks me to do work on other database systems. I have been asked to give a report of the file size of each table in a particular database. The database is one in our SQL Server. I have never done this even for FfoxPro. Is it possible without haveing to physically look at the properties of each(100+) tables? Can I use sql from FoxPro to get this report?

Steven,

I don't have my book right now with me so I can only search on the Web.

Here is one link:

http://sql-server-performance.com/Community/forums/p/20543/114899.aspx

I would guess this info is available in some of the system views.

You would be able to execute SP from VFP.