quote:

---

Thanks for the suggestions, I ended up using DMO, via TSQL. Here is my hack, if you are interested.

Declare @rc int

DECLARE @object int

declare @Output varchar(255)

Declare @Method varchar(255)

DECLARE @src varchar(255)

Declare @desc varchar(255)

-- Create hash for entered password

EXEC @rc = sp_OACreate 'sqldmo.application', @object OUT

IF @rc <> 0

BEGIN

EXEC sp_OAGetErrorInfo @object, @src OUT, @desc OUT

SELECT hr=convert(varbinary(4),@RC), Source=@src, Description=@desc

RETURN

END

set @method = 'ListAvailableSQLServers.count'

declare @cnt int

EXEC @rc=sp_OAMethod @Object, @method, @cnt out

IF @rc <> 0

BEGIN

EXEC sp_OAGetErrorInfo @object, @src OUT, @desc OUT

SELECT hr=convert(varbinary(4),@RC), Source=@src, Description=@desc

RETURN

END

declare @i int

set @i = 0

declare @name varchar(255)

while @i < @cnt

begin

set @i = @i + 1

set @method = 'ListAvailableSQLServers.item(' + rtrim(cast(@i as char)) + ')'

EXEC @rc=sp_OAMethod @Object, @method, @name out

IF @rc <> 0

BEGIN

EXEC sp_OAGetErrorInfo @object, @src OUT, @desc OUT

SELECT hr=convert(varbinary(4),@RC), Source=@src, Description=@desc

RETURN

END

print @name

end

EXEC @rc = sp_OADestroy @object

IF @rc <> 0

BEGIN

EXEC sp_OAGetErrorInfo @object

RETURN

END

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

---