Here is a solution not using CROSS JOIN:

SELECT A.*,

CASE WHEN EXISTS (

SELECT 1

FROM (

SELECT B.*,

(SELECT TOP 1 C.DEDate

FROM PersonRecord C

WHERE C.PersonID = B.PersonID AND C.VERSION >...

Thanks, it works. I just worried about the function DBCC showfilestats since I don't know if it will be cancelled in the future.

Anyway I can use it now.

Thanks for your reply. I'm looking for the Used and Unallocated DB space info which is available in the taskpad but not in the sysfiles, your solution doesn't provide such...

Thanks a lot guys. I'm writing a SP to find out all the circular reference tables in my DB. It will check to see if cascade delete and update is...