This script will get the name of each database from master..sysdatabases, then use each database's Information Schemata to get the tables and columns in each of the databases. Several recent requests for assistance have used this to answer their needs. I ran it across 245 databases and pulled back 1.4 million results in about 30 seconds. It doesn't need anything passed in, cleans up after itself when done, and be easily be changed into a Stored Procedure if needed on a repetitive basis. Enjoy.