• Create a DTS package with a Copy SQL Server Objects task that copies the objects but not the data to a documentation database (the task only works if copying between SQL Server databases) then schedule the package to run regularly.

    You can have a separate task for each database in the one package.

    Greg

    Greg