You are here: Re: listing SQL Server databases on a network « MsSQL Server « IT news, forums, messages
Re: listing SQL Server databases on a network

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

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация