I want to generate a report which includes server name, IP address, Port number, Instance name, database name, service account, version, edition and other information. I have more than 50 servers and want to hit same script in all servers. Is there any idea ? This is sql server 2005 environment. Any script or code, Plz help me.
Appreciate your help..