Posted by Steve on 12/07/05 16:08

Jens wrote:

> Hi Steve,
>
> what about this:
>
>
> Create Table #Serverinformation
> (
> Information VARCHAR(500)
> )
>
> INSERT INTO #Serverinformation
> EXEC('master..XP_cmdshell ''OSQL.EXE -L''')
>
> Select * from #Serverinformation
> Where Information like 'Somepattern'
>
>
> HTH, jens Suessmeyer.
>
Jens,

Looks promising. I presume that "OSQL.EXE" is an either an application or an
executable ActiveX object. If "OSQL.EXE" is not on our standard
workstations, then I will look on the server and use a query. Hopefully,
"OSQL.EXE" has an exposed interface to VBA; that would be ideal.

Best regards,
Steve Caldwell

[Back to original message]