Exactly what do you want to output to the text file and what do you want the text file for?

In Maintanence Plans, under the Reporting tab there is an item for the number of lines of history to keep for this maintenance plan. If this number is high, would...

This is, basically, the same except that it uses the information_schema views and not the sys* tables

This cursor will change the owner to dbo of all objects in the database (sprocs, views, etc)

It works on SQL2000, it should work on SQL 7

You can modify it to...