Posted by Jens on 12/07/05 15:26

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.

[Back to original message]