SQL Server list

[RL008]

I am trying to get all SQL server in my work network.

I kow how to do it in windows :

SQLCMD -L > c:\servers_filename.txt

Is there a way to do it in Autoit directly?

thanks

[water]

I am trying to get all SQL server in my work network.

I kow how to do it in windows :

SQLCMD -L > c:\servers_filename.txt

Is there a way to do it in Autoit directly?

thanks

You could use "Run" with flag $STDOUT_CHILD to get the output of SQLCMD into AutoIt

Or you could run an LDAP command against the Active Directory to query for "(&(objectCategory=computer)(servicePrincipalName=MSSQLSvc*))"

Edited May 10, 2010 by water

[RL008]

You could use "Run" with flag $STDOUT_CHILD to get the output of SQLCMD into AutoIt

Or you could run an LDAP command against the Active Directory to query for "(&(objectCategory=computer)(servicePrincipalName=MSSQLSvc*))"

can you please give an example of "Run" command and I/O ?

[water]

can you please give an example of "Run" command and I/O ?

A running example can be found in the help file for the command "StdoutRead"

[RL008]

A running example can be found in the help file for the command "StdoutRead"

thanks!