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.

• Next in forum: Re: listing SQL Server databases on a network
• Prev in forum: listing SQL Server databases on a network
• Thread view: Re: listing SQL Server databases on a network

[Reply to this message]