List all SQL Servers in multiple domains

[Osiris85]

Hi There,

Does anyone know about a script or something to list all SQL Servers on multiple domains?

I've currently got a script for SQL 2008 that shows all SQL Servers on a domain.

It's as follows:

BEGIN
SET NOCOUNT ON

CREATE TABLE #servers(sname VARCHAR(255))

INSERT #servers EXEC master.dbo.xp_cmdshell 'OSQL -L'
-- play with ISQL -L too, results differ slightly

DELETE #servers WHERE sname='Servers:'

SELECT LTRIM(sname) FROM #servers WHERE sname != 'NULL'

DROP TABLE #servers
END