We have everything from SQL 2005 up to SQL 2008R2 SSMS.

I currently have a SQL 2005 server where i have all others added as linked server.

Thanks again for your ideas...

Hi,

I can create an excel sheet with the DB names but how should I create the script to read the dbname from the file?

Regards

angelspawn