Thanks crow1969 that worked like a charm.

Yes, I can do this but I get an error when I try to test the connection but I think I found my issue. I need to setup alias which...

Thanks for answering my questions Gazareth!

Thanks ALZDBA, I have never really used powershell but I have browsed over the demo and it maybe something I will look into.

As for the T-SQL script it worked...

Thanks ScottPletcher, I will definitely set up a db that I can use to store all this.

Also thanks TheSQLGuru, I have taken a stab at the script you provided...