Re: How can I obtain all the SQL SERVER's names in my domain

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 06/28/05 

Date: Wed, 29 Jun 2005 00:10:52 +0530

Hi,

Try the below command from command prompt.

OSQL -L

Thanks
Hari
SQL Server MVP

"Enric" <Enric@discussions.microsoft.com> wrote in message
news:85E1BA68-3430-4807-BCC0-FD77AB8698A9@microsoft.com...
> Dear all,
>
> Regarding the aforementioned question I don't know if launching one script
> in VB
> and retrieving all the names is compulsory.
>
> Is there any way or method for obtain that info via job/sp?
>
> I hope have been sufficiently explicit.
>
> Thanks in advance and regards,

Relevant Pages

  • Re: & Now, a Script to List the Running Process Info - Re: Useful little Script to Show the
    ... Done that to the desktop folder, ... at a Command Prompt, with the Name of the Script File (after a Space, ... a Folder where the Command Prompt Opens (either the Root of the ...
    (uk.people.silversurfers)
  • Re: Finding members of RDP groups of a list of computers
    ... got the script to work by double clicking the vbs file. ... cscript //nologo RDPMembers.vbs> report.txt from the command prompt? ... MVP Directory Services ... Your text file of computer names must be located in a folder on ...
    (microsoft.public.scripting.vbscript)
  • Re: Fully Disable Command Prompt
    ... I found if I disable the command prompt script ... As for ntfs permissions, hows this for an odd one. ... >as in the dllcache folder or service pack files folder. ...
    (microsoft.public.win2000.security)
  • Re: export account details from an OU
    ... The script can be run on any computer authenticated to the domain. ... I would run it at a command prompt with the cscript host. ... Const ADS_SCOPE_SUBTREE = 2 ... Set objConnection = CreateObject ...
    (microsoft.public.windows.server.active_directory)
  • Re: Perl vs. W2000
    ... >default to the test directory on c: via the command prompt (e.g., ... in a perl script it is normal to have the first line start with: ... >different from where the script resides, ...
    (microsoft.public.win2000.general)