>Is there a way to programmatically loop through the databases in SQL Server?
>
>something like the following pseudo-code?
>

>nDatabases = sqlServer.NumberOfDatabases
>
>for i = 1 to nDatabases
>   insert into sqlServer.ArrayOfDatabases[i].TableName , yada, yada...
>endfor
>

You can use INFORMATION_SCHEMA view to get list of databases

SELECT * FROM INFORMATION_SCHEMA.SCHEMATA