• John, I was talking about connecting to sql 2000, in which case sys tables are still there. U r right, in 2005 you'd want to use DMVs.

    Just to nitpick a bit (it was a nice article), but last I heard the systables are being depricated, as well, in favor of the system views. As such you would want to do away with the calls to sysobjects:

    SELECT name FROM sysobjects

    should be

    SELECT name FROM sys.objects

    and

    Select crdate as DateCreated

    From dbo.sysobjects

    should be

    Select create_date as DateCreated

    From sys.objects